CSV file data from one column to multiple columns

Hi Everyone… I have a CSV file having data in one column only, Data have to be split from one column to Multiple columns…
Here is my Input screenshot

Output as to be


Can you open your file in notepad and share screenshot of that, a csv must be delimited by something in order to section correctly.

Your current input(first image) is very difficult to split accurately / efficiently because there is no identifiable delimiter

Hi @TimK…Can i share my inpute csv file!!


Sure :slight_smile:

Can you upload it or can you put it on a google drive or fileshare?

Hey :slight_smile:
So you can use Read CSV activity, and in the properties panel change delimiter to Tab

Thanks @TimK…It’s working…!!!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.