cancel
Showing results for 
Search instead for 
Did you mean: 

CSV to Collection

VitorMoreira1
Level 2
What is the best way to convert a .csv (comma separated) to collection when all the values is in the first column?
1 REPLY 1

AlesiaDzerhacho
Level 2
Hi, First of all you should try the following action from Utility - File Management - Get CSV Text As Collection. This should work for comma separated values. Else, you can read file using Utility - File Management - Read All Text from File, so you get a Text data item which contains all data from your file. And then split text into collection using Utility - Strings - Split Text.