How to Separate "Comma" and "Tab" delimited csv

Help Studio
1

Hi, I have multiple CSV file, and each file has a different format
“Comma” and “Tab” delimited format and i want to separate them while the Bot looping in One folder.

Any advise how to do it?

Thanks in advance
-Vincent

2

You could first read the entire file into a string variable and then use Contains to check if it has “,” in it (assuming your CSV uses the “,” notation between columns)