excluding a column in csv file with regex
Posted
by JPro
on Stack Overflow
See other posts from Stack Overflow
or by JPro
Published on 2010-06-14T12:31:56Z
Indexed on
2010/06/14
12:42 UTC
Read the original article
Hit count: 167
Is there any way to exclude/delete/replace one field from a csv file with some regexp in notepad++?
I have a csv file with some data like this:
'1','data1','data2','data3','data4','data5','data6','data7','data8','data9',
'data10','data11','data12','data13','data14','data15','data16','data17','data18',
'data19','data20','data21','data22','data23','\'data24 with some commas,
here and there and some "double quotes", and fullstops.','data25','data26'
The only problem I am facing is with data24
WHERE I encounter \'
and then ""
and some wild characters like ,
and .
. This is particularly fixed at 24 field.
For the purpose of clarity, I have entered a newline here. But the entire text above is in juts one line.
Any ideas on how to solve?
Thanks.
© Stack Overflow or respective owner