reCsvEditor Activity
Editor for simple (only one record type) Csv Files.
Status: Beta
Brought to you by:
bruce_a_martin
Activity for reCsvEditor
-
Frédéric Donckels modified ticket #9
Sources?
-
ok, thank you
-
Bruce Martin posted a comment on ticket #9
The source code is store in the RecordEditor project: https://sourceforge.net/p/record-editor/code/HEAD/tree/
-
Sources?
-
Anonymous posted a comment on discussion General Discussion
Hi, Thank you for this software. I found it by searching for software to edit csv format data files where some fields have quotes, and I need to be able to keep those. Can you clarify how to delete a column? The view always highlights a row? I'd also like to move the contents of several cells-how can that be done? Thank you, A
-
KDB posted a comment on discussion General Discussion
Thank you for the quick response. I wanted to change the location of this directory: "C:\Users\user\.RecordEditor\reCsvEd" To something like this: "C:\reCsvEditor" So the Params.Properties, ParamLists.Properties, and UserJars.txt would be located in "C:\reCsvEditor". Similar to a portable installation. I had looked at the ReCsvEditor_USB_0.99.2 files, but not closely. A closer inspection .... ReCsvEditor_USB_0.99.2 includes a "parms" folder. I added a "parms" folder to my 0.99.3 install. I found...
-
To change the directory where the Editor opens: Select Edit >>> Edit Options primary menu option Select the Properties tab on the left hand side of the options screen Change the Directory where the Editor opens in option (second from the top). See the attached picture Press the save button at the top of the screen.
-
Is it possible to modify the location of the User files. Per Edit - Edit Options - Description, the User files are are located at C:\Users\user.RecordEditor\reCsvEd. I changed all the locations in Properties - Directories tab and Save Directories tab, but that did not change the location of the User files. I looked for a parameter / switch to use on startup but did not find one. I am probably missing something. Thank you. Windows 10. reCsvEd 0.99.3.
-
reCsvEditor released /reCsvEditor/Version_0.99.3/reCsvEditor_Installer_0.99.3.jar.zip
-
-
-
Quotes in a CSV refers to having a Quote at the start and end of a field. e.g. 111|"Field 2"|333 444|"Field with ""|"" a bar"|666 in the above case you would specify a quote of ". In the example below you would not specify a quote 111|Field 2|333 444|Field with a "quote"|666 CSV means Comma separated values. Problems arise if you use a comma in a field e.g. field 1,Comma, in a field,field 3 in the above example, field2="Comma, in a field" but the line would be passed as field1 = "field 1" field2...
-
Anonymous posted a comment on discussion General Discussion
First, sir, thank you for this wonderful program and your hard work, and I do not want to cause you any inconvenience. I simply think I do not know how to do something which to you may be obvious. The filed break is the vertical bar. It asks me what I want quotes to be. I read your 2013 post announcing to a user that you added this feature. My cvs uses " within several records in one or more fields. Shouldn't I set this to " then too? I assumed I should do so, and I have, and now I have this problem...
-
buhtz posted a comment on discussion General Discussion
Your are the upstream maintainer, right? You are the core developer also, right? So how could it be that you do not know? You know the internas and the libraries that your software use to read and show CSV's or table data. Maybe you can do an assumption or do a test.
-
What about 150.000.000 rows with 32 columns (~15 GB uncompressed file size)? - I do not know for Csv files.
-
Please be more clear with the support of "very large Files". What does it mean in columns, rows and/or disk file size? What about 150.000.000 rows with 32 columns (~15 GB uncompressed file size)?
-
malc posted a comment on discussion General Discussion
Thanks, that fixed it.
-
Change the Tab to unicode the Font to UTF-8
-
Change the Tab to unicode the Font to UTF-8
-
Hi, I'm trying to work with MoJ stats files from here https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/888561/csvs-behind-data-tools-2-2019.zip The one I'm trying to use is HO-code-principal-offence-2019.csv. This appear ok in the preview in file open but when I click edit the data in the columns is all jumbled
-
Google Regular Expressions or look at info. The expression Basically . - any character. *- any number of repeats of the preceding character So is .* is any character string (0 or more characters [^-\s] means any character that is not white space (space tab). So .*[^-\s].* is Chacter string of any length Noon blank character Chacter string of any length
-
Anonymous posted a comment on discussion General Discussion
Thanks. Very Strange but I'll try it. What does it mean?
-
You can use a regular expression check of: .*[^-\s].* see atached picture:
-
You can use a regular expression check of: .*[^-\s].* see atached picture:
-
looks like no; I will update program
-
Anonymous posted a comment on discussion General Discussion
Is there a way to filter for "field not empty" by using some sort of wild card that means any character? Thanks.
-
Thank you for the reference
-
s-r-grass created ticket #8
Thanks for the program under a free open source license!
-
The find and filter screens have a Filter operator Find Filter
-
The find and filter screens have a Filter operator
-
Anonymous posted a comment on discussion General Discussion
any changes on this front? Woulbe be incredigly useful.
-
-
-
-
-
No problems, I generally try fix issues (if life allowa any way). There are a lot of possible variations in computer setup and I can not test everything so Stack traces are very useful. Glad you find the editor usefull all the best Bruce
-
Jester Elly posted a comment on discussion General Discussion
hey bruce, my pleasure! the issue is solved, THANKS A LOT for your work - you're amazing!!! this software is pretty cool and so you are! we don't have to switch to the "evil side of life"OS from mr. "NWO by mandated vaccination for everybody with plenty of microchips and side effects" devil himself bill g. anymore to use your software...thats very nice and feels pretty good, espc in these times.
-
Thanks for the Stack trace, I think I have fixed that issue. I have uploaded a new version of trial1: ttps://sourceforge.net/projects/recsveditor/files/reCsvEditor/Version_0.99.0/ReCsvEditor_USB_0.99.2_trial1.zip/download
-
-
hey bruce, thanks for your answer! we are still encountering a number of java-errors (see attached screenshot), so we can't use the editor on ubuntu 18.04 right now... would be really cool to solve these issues so we can implement you great piece of software into our everyday-workflow again.
-
I have uploaded an updated USB version which should work in Java 11. See https://sourceforge.net/projects/recsveditor/files/reCsvEditor/Version_0.99.0/ReCsvEditor_USB_0.99.2_trial1.zip/download
-
I have uploaded an updated version which should work in Java 11. See https://sourceforge.net/projects/recsveditor/files/reCsvEditor/Version_0.99.0/ReCsvEditor_USB_0.99.2_trial1.zip/download
-
-
In jave 11 a number of classes / methods where removed. I am in the process of updating ReCsvEditor to get it to work with the latest versions of Java
-
We're using the editor for a while now and without flaws on Ubuntu 16.04 LTS. Since we've upgraded our systems to Ubuntu 18.04 LTS, the editor doesnt work - neither the installation nor the standalone USB - version. Java environment is up-to-date, so we can't figure out whats the problem here and sadly have to use other apps for our taks. Anyway thanks for your great work!
-
If you have the time Can you run the attached extract program on the file. There are sample bat and shell-script programs included Steps: extract the zip file in the same directory as the problem file run java -jar extract.jar Problem-File-Name You can update the supplied bat/shell script A new file Problem-File-Name.extract.gz will be created note : the program does not support spaces in the file-name
-
Rosemarie Wilton posted a comment on discussion General Discussion
Hello, I tried the Unicode Csv, but had same results. I did manage to find another way to get rid of the extra lines using Pandas, so if ReCsvEditor doesn't work, I have another option. The zipped file is 180 MB. Thanks much. From: Bruce Martin bruce_a_martin@users.sourceforge.net Sent: Monday, March 30, 2020 6:27 PM To: [recsveditor:discussion] general@discussion.recsveditor.p.re.sourceforge.net Subject: [recsveditor:discussion] File becomes jumbled in Edit mode From the first screen, Try clicking...
-
From the first screen, Try clicking on the Unicode Csv tab and pressing Edit from there How big is the file when zipped up ???
-
Hello, I attached the screen shots below. I was initially trying to work up the data using R, but because of the few rows at the top of the file, R was interpreting this as a two-column file (and with my beginner R knowledge, I couldn't figure out how to fix). I would like to get rid of those lines and try again. Someone recommended your reCsvEditor to me (file has about 1900K lines). Thanks so very much for your help! [cid:image002.jpg@01D6067F.A5A97DD0] [cid:image004.jpg@01D6067F.A5A97DD0] From:...
-
Can you provide screen prints for the startup and eidt screens. Also can you go into Text View (Top menu View >>> Text View see attached picture) and copy the first thirty lines ??? S
-
Hello, I am trying to edit a large CSV file (specifically, I'm trying to remove the first 7 rows which contain metadata). The file looks normal in the initial preview window, but when I go to Edit, the resulting file is jumbled. It may be using different characters to assign column separation, but I can't figure out why. There are different types of symbols in the various column entries, like / , : , []. Could these be the problem? I'm not sure how to select the proper Parser and Field Seperator...
-
Michael Karas posted a comment on discussion General Discussion
thanks for your fast reply. I didn't see sourcecode in Record Editor but not for reCSVEditor. Now I realizied that it is integrated in Record-Editor Source. Next tiem I will investigate first in the existing source. Actually I will use it for viewing/cecking differents CSV-Files we get from ou data-deliveries (Mainframe, Unix-Server and Windows-Server).
-
The source is available here: https://sourceforge.net/projects/record-editor/files/Test/Version_0.99/RecordEditor_Source_0.99.zip/download or in subversion: https://sourceforge.net/p/record-editor/code/HEAD/tree/ the Zip download is the better option to use. Not sure how well it will work in Java 11; The jibx xml code. One jar that is used is JRecord_CodeGen (mainly Jana/JRecord code generation) This uses Jaxb. You probably would not use it. I am in the process of removing JaxB and Jibx from the...
-
The source is available here: https://sourceforge.net/projects/record-editor/files/Test/Version_0.99/RecordEditor_Source_0.99.zip/download or in subversion: https://sourceforge.net/p/record-editor/code/HEAD/tree/ the Zip download is the better option to use. Not sure how well it will work in Java 11; The jibx xml code. One jar that is used is JRecord_CodeGen (mainly Jana/JRecord code generation) This uses Jaxb. You probably would not use it. I am in the process of removing JaxB and Jibx from the...
-
The source is available hereL https://sourceforge.net/projects/record-editor/files/Test/Version_0.99/RecordEditor_Source_0.99.zip/download or in subversion: https://sourceforge.net/p/record-editor/code/HEAD/tree/ the Zip download is the better option to use. Not sure how well it will work in Java 11; The jibx xml code. One jar that is used is JRecord_CodeGen (mainly Jana/JRecord code generation) This uses Jaxb. You probably would not use it. I am in the process of removing JaxB and Jibx from the...
-
Hi is there sourcecode available? Want build it for Java11. thanks and knd regards Michael
-
Anonymous posted a comment on discussion General Discussion
It works very well, tx
-
Anonymous posted a comment on discussion General Discussion
Tx Gona give it a try tomorrow Kim
-
I have updated ReCsvEditor to allow Regular-Expressions to be used to be used in a scchema. This update is available as USB style download - Unzip the tin any normal unprotexted directory (not c:\Program DFiles). It is available at: https://sourceforge.net/projects/recsveditor/files/reCsvEditor/Version_0.99.0/ReCsvEditor_USB_0.99.0a.zip/download This change allows RegularExpresions to be used in schema's. You can view the file and Export as Csv but you can not update / Save the file. There is a Schema...
-
I have updated ReCsvEditor to allow Regular-Expressions to be used to be used in a scchema. This update is available as USB style download - Unzip the tin any normal unprotexted directory (not c:\Program DFiles). It is available at: https://sourceforge.net/projects/recsveditor/files/reCsvEditor/Version_0.99.0/ReCsvEditor_USB_0.99.0a.zip/download This change allows RegularExpresions to be used in schema's. You can view the file and Export as Csv but you can not update / Save the file. There is a Schema...
-
-
Anonymous posted a comment on discussion General Discussion
hi 376513.782 6802065.212 {61.3330312,6.6923147,79.18,59} 376508.214 6802065.877 {61.3330354,6.6922103,76.59,54} 376509.145 6802065.844 {61.3330354,6.6922277,77.18,59} I want this file to be separated by: Space , Comma, } and {
-
Basically no, You can setup define array's (via xml schema) which may work ??? Array fields example (: used for array) Normal Field,Array Field,.... 111,aa:bb:cc,... Can you provide sample data and a more detailed eplanation of what you want to achieve ???
-
Anonymous posted a comment on discussion General Discussion
Hi Tx for a great piece of software. Im in need of being able to split my data with several different seperators. Im converting geogaphic info that is seperated with comma, and the software outputs the converted data with comma, but all the othe data like depth og height come separated with space. and there is a couple of { and} in there also. So if i could separate the data with several separators, and then export it with only the rows i need it would be perfect. Best regards Kim
-
Bruce Martin modified a comment on discussion General Discussion
Can you show me the relavent lines ??? Can you try selecting the embedded New Lines option. See attached picture Getting the Relavent lines in ReCsvEditor In ReCsvEditor you can Select a small range that includes the problem line Select menu item View >>> Table View selected Records Select menu item View >>> Text View or View >>> Text View (highlighted fields) That should display a portion of the file as standard text
-
Can you show me the relavent lines ??? Can you try selecting the embedded New Lines option. See attached picture
-
Can you show me the relavent lines ???
-
Anonymous posted a comment on discussion General Discussion
Hello, imported very large voter database located at https://www.elections.ny.gov/NYSBOE/download/ZipDataFiles/ALL_REPORTS.zip At verious times the record breaks incorrectly and splits the records. If you perform the import, see line 230260. This happens at various intervals throughout the import. When looking at the file in a txt viewer there doesn't appear to any issues with the data that would cause these breaks. The records have the following accompanying definitions: (RecordSeparator): CR-LF...
-
-
-
-
-
-
-
VLookup is more of Spreadsheet function. It might be possible to do usinga Macro but it would be just as easy in python script.
-
Not at the moment - I will have look at though
-
Chilly Bang modified a comment on discussion General Discussion
Is there a way to perform a kind of VLOOKUP between two tables? I have two tables, in the first one i want to get some data from the second one, based on one column, like =VLOOKUP(table1!A2,table2!A:B,2,0)
-
Is there a way to perform a kind of VLOOKUP between two tables? I have two tables, in the first one i want to get some data from the second one, based on one column, like =VLOOKUP(table1!A2,table2!A:B;2;0)
-
I will have look at it, any of the following would be useful any messages How did you delete the column how big was the file which column - first last, middle which version of Recsveditor, which version of java
-
I will have look at it, any of the following would be useful any messages How did you delete the column how big was the file which column - first last, middle
-
Anonymous posted a comment on discussion General Discussion
WTF?? Why this soft crashed afther delete column larges csv??
-
I think probably want a search text of .*TCA.*TAG.* What TCA.*TAG does is look for a fieldwhere the first characters in the field are TCA and the last character in the field are TAG
-
Anonymous posted a comment on discussion General Discussion
Hi Bruce, I updated my version and have now 0.99_trial_5. I tried to use your solution (see picture attach) but it return no match :(. Can you tell me what did I do wrong? Thanks, Cédric
-
-
-
-
-
-
-
Simon Dorr posted a comment on discussion General Discussion
am now registered. You should be able to send me an email
-
Simon, create a Sourceforge account and specify your e-mail (probably have to these days). I can then use your sourceforge account to send you my e-mail addrress. It also means I do not need to moderate your posts
-
Anonymous posted a comment on discussion General Discussion
thank you very much for the outstanding support I can provide more files, one where I discovered a bug, but it would be nice if I could do this via mail and not uploading it for the world. Sadly, I will not be availible on the weekend have a nice friday Simon
-
In https://sourceforge.net/projects/recsveditor/files/reCsvEditor/Version_0.99.0_Trial_4/ I have uploaded updated ReCsveditor with 2 fixs for the example file reCsvEditor_099_Trial4a_Upgrade.zip - Holds upgrade jars, copy over existing ReCsvEditor instalation ReCsvEditor_USB_0.99_Trial4a.zip - latest USB version Suggest trying the USB version - unzip it in a normal directory. You should be able to Right click >>> set as Field name row on the line with the column names It will display all lines; but...
-
In https://sourceforge.net/projects/recsveditor/files/reCsvEditor/Version_0.99.0_Trial_4/ I have uploaded updated ReCsveditor with 2 fixs for the example file reCsvEditor_099_Trial4a_Upgrade.zip - Holds upgrade jars, copy over existing ReCsvEditor instalation ReCsvEditor_USB_0.99_Trial4a.zip - latest USB version Suggest trying the USB version - unzip it in a normal directory. You should be able to Right click >>> set as Field name row on the line with the column names It will display all lines; but...
-
-
-
Anonymous posted a comment on discussion General Discussion
the Column names line number field works in some cases, but i'd prefer to not show the text above the name line at all. See the attached file. Something in the "header" makes it unreadable. From line 25 onwards it will be a valid CSV
-
I just want to ignore those lines. Either by ignoring a fixed number of lines or by ignoring a specific pattern. Is this possible?` Depends If there are blank lines before the Column header lines you can use Column names line number field See attached picture If there is no Column names it might be possible via a schema (need to check). Can you provide sample files Xml Documentation not yet, I will try and write some. What sort of riles do you want to want to write schemas for ??? can you provide...
-
Anonymous posted a comment on discussion General Discussion
Hi and thank you for providing this application, when handeling automaticly generated CSV files, those files will often have some sort of header, that may also contain the delimiter, but not belong to the data. I just want to ignore those lines. Either by ignoring a fixed number of lines or by ignoring a specific pattern. Is this possible? On a sidenote: Is there a documentation on the attribute options in an XML Schema? For me, it would be way easier to edit the XML directly than to use a GUI greetings,...
1 >
