Multiple .txt files in a directory with different delimiters (per .txt file)

Dear all,

I have been reading the forums but haven't found the solution that solves my issue. It sounds simple, but I might be over thinking it. Here is the problem.

I have a list of paths of .txt files which I am passing on to my dynamic input tool to read and aggregate the data. The issue is that of the 24 .txt files, half has "tab \t" delimiter, the other half had "~" as delimiter. The 50-50 is random, so can't group them and split the dynamic input. The next input file could be one or the other.

How do I go about solving this. I tried applying no delimiters \0 but it doesn't work, I lose files or some reason.

Any help is appreciated.

Thanks,

Aksel

Input

Accepted answers

VickyA

Have you tried reading them with no delimiters first and not taking first row as headers.

Then use a formula tool to replace both delimiters into a common delimiter.

All comments

VickyA

Have you tried reading them with no delimiters first and not taking first row as headers.

Then use a formula tool to replace both delimiters into a common delimiter.

VickyA

What I mean by no delimiters is remove the \0 from the Delimiter option and leave it blank.

aetingu33

Thank you, for some reason I was over complicating it.

Removed the delimiters, Replaced the delimiter '~' with tab delimiter, applied text to columns and then added back the header. Perfect!

Thanks a million.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703