I do have CSV file and need to extract data where 4 columns in single column

Help Studio
, ,
1

hi all

my intial csv file is like this
image

i do have CSV file and need to extract data where 4 columns in single column
you can see below image

image
image783×275 32.5 KB

i need to add each vale in individual columns

like below

image
image696×121 15.1 KB

Thank you!!!

2

Open it in Notepad, not Excel, and figure out what the column delimiters are. Then use Read CSV and set the delimiter property correctly.

3

image
image736×187 3.43 KB

4

That doesn’t look like a proper CSV file. There is nothing between the columns. What’s the source of this file, can you get a proper file format?

5

Do you have an example of the file with multiple rows of data?

6

output.7z (239 Bytes)

7

I can’t open .7z files. Just copy paste a few rows of the data here.

8

can you share the note pad file its not opening

@vineelag