Rosemarie Wilton

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...

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:...

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...