Convert txt to xlsx w/ double delimiter - tab & tilde

I have a TXT file that I am trying to convert to xlsx that is delimited by both tab and tilde. I have done this one with delimiter but not with two. I’ve used the ‘Read CSV’ activity in the past with a simple delimiter but in this case tilde is not an option, neither is multiple delimiters. Looking for suggestions on how to do this. Thank you!

give a try on split/replace tab and tilde to a common delimeter with the help of regex
then pass it to generate datatable activity

do you have some sample lines for reference?

2 Likes

Hi,

Hope the following sample helps you.

Sample20211216-1.zip (2.4 KB)

Regards,

1 Like

This worked perfectly! Thank you so much, I appreciate your help!

The example below worked for me. Thank you for your response!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.