Separate Collections value

Hi There,

I've designed a flow that extracting data from CSV file and I've used "Read lines from file" to get the data into collection. But both the columns have been merged with .(dot). You can refer attached screenshot.

Kindly help me to separate both the columns and store the values in different collection with headers.



Hi Shubham,

Thanks for the reply. But your solution didn't work. Simply using MS Excel VBO is not solution there must be some option which separate both the values based on the (.) dot

Use Split function [using delimiter(.)] in Utility String VBO to seperate the text and add the new column in collection in which u can store the text after the period in new column.