Replacing CSV delimitators

Question

I'm trying to replace a csv delimiters using regular expression, but can't get my head around the parameters.

Sample text:

2136203,"asd asdd","17 - Alpha","13 - Scsdeori Colsden",05.04.12,A,255659,"VOSDEFER ADEDEAN","SER.HDEDEA NR 52 BL - SC - AP -, PDEXTA, AEDD, CP 312337",RO26A34498,20.04.12,,12.04.12,"Confsdare"

I want to split the string like this:

2136203
asd asdd
17 - Alpha
13 - Scsdeori Colsden
05.04.12
A
255659
VOSDEFER ADEDEAN
SER.HDEDEA NR 52 BL - SC - AP -, PDEXTA, AEDD, CP 312337
RO26A34498
20.04.12
1. 12.04.12
Confsdare

Explain your problem and also what do you actually want to achieve — this-Me, Apr 23 '12 at 12:05
I want to replace the csv text qualifier and delimitators with "|" — XandrUu, Apr 23 '12 at 12:10

score 1 · Answer 1 · edited May 23 '17 at 12:14

1

Use the example on the top answer here to parse the file.

This turns your file into a string[] you read one row at a time.

Then write out a new file with the format you need.

edited May 23 '17 at 12:14

Community

1
1

answered Apr 23 '12 at 12:13

jonathanpeppers

26,115
21
99
182

Replacing CSV delimitators

1 Answers1