1
vote
2answers
142 views

Notepad++ Regex Help in cleaning up file

I've got a csv file (the column separator is "<;>" ,the text delimiter is the double quote and the row separator "crlf") of more than 18000 lines. However,many of the data contained within the ...
1
vote
2answers
186 views

How to import this data set into excel? (column headings on each row delimited by a colon)

I'm trying to import the following data set into Excel. I've had no luck with the text import wizard. I'd like Excel to make id, name, street, etc the column names and insert each record onto a new ...
3
votes
3answers
160 views

regex help - ignore a char if it's in quotes

We have a web-based app at work where you can enter a regex into a search box and it returns the matches from a database Here's a sample of what the database entries might look like. They're comma ...
8
votes
8answers
5k views

Notepad++ - Removing the first column in a comma separated file

I have a large CSV file that I need to remove the first column of data. I cannot open it in Excel because Excel converts some of the values in the columns to scientific numbers. I am using Notepad++, ...
0
votes
4answers
2k views

RegEx to Remove CRLF from CSV export from Excel

I exported an Excel File to CSV and do have a lot of multi-lines within. I marked the beginning of each line with * and the end with ###. *** some text within my cell to export ### Could someone ...
1
vote
1answer
119 views

Regex to join fields in a CSV

I have a CSV with over 2 million records in it with the following format. path;name;extension;size;date;user /foo/;difacs;cgi;3,795;18-07-2011;Unix User\pads ...
0
votes
1answer
332 views

Linux replace ^M$ with $ in csv

I'm working on migrating from MDaemon to Google Apps. As part of this process I'm exporting the contacts and calendars for all of our users into CSV files then reading them into a perl script and ...
0
votes
2answers
1k views

Notepad++/Regular Expression to find line with same beginning, different ending

So, I've read a bit and found NotePad++ doesn't use "normal" regex (starting to think I'll just go back to SciTE), but here's my question: I've got an exported list of data with some redundant data ...
1
vote
1answer
75 views

regex for searching a word in a word

i have a csv file which i need to filter mails marked with the word 'spam' lines look like this email;text;somestatus;mailserver status response; response message ...