excluding a column in csv file with regex
- by JPro
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.