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

Question

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 Answer

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