Separate data present in cell into columns

Hello,

I’m extracting data from Instagram, but the data is scraping like this:

abhishek_changan
Abhishek Changan
Following

All this in one cell.

How can I separate it into columns?

Regards,
Abhishek

Hi @Abhishek_Changan

Did want finally like this ?


Then check this workflow
sample_12.zip (2.9 MB)

Hope it helps you

Regards

Nived N
Happy Automation

2 Likes

If you use Split function to split based on NewLine character, it should give you each row as a separate value.
Assign → String[] values = InstagramString.Split(CChar(Environment.NewLine))

I hope this will help.
InstagramDataSplitter.xaml (5.2 KB)

2 Likes