Separate Collections value

waziaks

Member
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.

Thanks
Waziaks
 

Attachments

  • collection_ques.PNG
    11.3 KB · Views: 25

waziaks

Member
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

Thanks
 

jaganrpa

New Member
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.
 
Top