Opening Up CSV from Filepath with Delimiter

[MarkM87]

Hi All,

Looking for some help. Creating a workflow which relies on using the Directory tool.

I have the filepath, the file I am looking to open is a CSV but has a delimiter (~) that i cannot seem to open when I use the Dynamic Open tool.

What happens at the moment is that i get an error message saying that there are "Too many fields in record".

Can anyone share with me the layout of something that would work to open the file i am after? Or perhaps a workaround to achieve the same results?

Thanks in advance!

Mark

[DataNath · Accepted solution]

Hey @MarkM87, if I'm understanding your ask correctly, have you tried changing the Delimiter configuration when you set up the template input? You can enter any delimiters here - option 5.

[MarkM87]

Hey, thanks for coming back! I am not using the Input tool. The current method im using:

- Opening all file paths using the Directory Tool

- Isolating the files that I need

- Using the Dynamic Input tool to open the files from the relevant fullpaths

Because the csv is using a delimiter, I dont know how to consume all the data because of the error message I get.

Thanks in advance!

[apathetichell]

use a batch macro. don't use dynamic input. True story - with a batch macro you can change the filepath, delimiter and first line of data for each file. Those can all be dynamic. 

[MarkM87]

This is correct. Apologies, i forgot that there was a delimiter option in the template section of the dynamic input.

Thanks !