CSV to Collection
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-10-18 05:03 PM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
30-10-18 10:27 AM
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.
