Help: Text to Column / Regex on txt file

[pchong]

Hi there,

I am having difficulty reading text files. (Attached for reference)

This was what I did with my input tool:

Ultimately, I want to achieve a proper text to column that look like this :

However, row 2 to 5 will shift to the left because of blanks under column Date3

I would also like to avoid problems with any empty columns like above.

What is the best way to do Text to Column or Regex to get my desired result here?

Thank you.

[pchong]

Hi @afv2688 ,

I'm just wondering how I create this flat file from scratch.

Can I set the width, then export the format to a txt file from Alteryx?

If I would like to import the flat file to different files every day, is it just as easy as changing the file path?

Thanks!

[afv2688]

Hello @pchong ,

this is just a small example showing how to create a flat file, you just have to add the needed info.

Regards