ReadCSVFile activity ~ delimited

Help
1

I need to read a ~ delimited CSV file, but there is no option to specify a customer delimiter - other than those in the dropdown. My CSV is delimited using ~

Is there a workaround for this?

2

Hi @andrewjames

Read the csv file as text file and than replace (~) with the delimeter option available in the drop down

then read csv file the available delimeter

1 Like
3

I’ve gone with:
Read Text File activity to read the file into a variable
Generate Data Table from the variable specifying ~ as the delimiter

2 Likes
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.