How to open multiple csv files which have different delimiter when using wildcard

[acaryasin01]

Hi guys,

While opening multiple csv files which those have same table but different delimiter.

For instance some of them comma ( , )  the others pipe ( | )

How can I use these two or more delimiter while openin multiple csv files?

Thanks in advanced :))

[Maskell_Rascal · Accepted solution]

Hi @acaryasin01 

You can't do this strictly with the Input tool. You would first need to input all files with a non-delimiter "\0". 

Once the files have been input, you can then use a Text to Columns to parse out the fields using multiple delimiters. 

Hope this helps. 

Cheers!

Phil

[acaryasin01]

Thank you so much @Maskell_Rascal