How to read CSV which contain ';'

[swanand_deshmukh]

Hello guys here is my question is im trying to read csv but it contain  +
so how can i read this by ignoring  +

what i did is, i change the delimiter to tab but while extracting data from csv it gives all row data in one row
please help me guys

Thanks!!

[mukeshkala]

hi @swanand_deshmukh

You can read the csv file as Text and then replace the + with a Comma .
Then Try to Read it using Read Csv.

–
Mukesh

[swanand_deshmukh]

Thanks mukesh but its not + it is ’ +’ in first row thats why while reading csv it throws exception

[mukeshkala]

Can you attach he CSV here , you can delete the actual data and provide one with sample data

[swanand_deshmukh]

yess sure

here is:Sample.zip (353 Bytes)
Thanks

[dfilipovic (Dino Filipović)]

@swanand_deshmukh, can you send unmodified sample?

[swanand_deshmukh]

here is:Sample.zip (353 Bytes)
Thanks

[dfilipovic (Dino Filipović)]

Hello @swanand_deshmukh,

there were a lot of special characters and I had to remove text data from first row to here:

I have created workflow which works, I am converting a string to list then I am removing range from first character to position which I have drawn in picture.

dinofilipovic/How_to_read_CSV_which_contains

Cheers,
Dino

[swanand_deshmukh]

Thank You so much…it works

[swanand_deshmukh]

sir can u explain me what did u in that sample process coz it remove date also and actually i want that date in that excel and want to remove special excretion

[dfilipovic (Dino Filipović)]

Hi @swanand_deshmukh,
in method which I have used for this purpose Remove Range has inputs which is starting index and end index which I wanted to remove (you can check that print screen from Notepad++ where you can see special characters and why it is 20).

You can check information when you select this activity and open Parameters part:

You can put set up to remove range from 0 to 16 then apply remove range for 2 to 3 because first remove range will clean data from ranges 0 to 16 then index will be moved where 0 index will be your date, 1 index will be colon character, 2 index will be ‘cr’ and 3 index will be ‘LF’, explained in this image:

Cheers,
Dino

[swanand_deshmukh]

Ok i got it but if i want to remove unwanted specific csv cell data like for example,

in above image i want to remove second remove range i.e. date and i want before second remove range data and after remove range data so how can we do it.

Thanks !!