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

[aetingu33]

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

[VickyA · Accepted solution]

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.