SAP text files input on alteryx and the format changes

[John_Sar-1937]

Hello to everyone,

I am dealing with a problem whenever i am trying to input SAP text files on Alteryx. While the primary TEXT FILE is ok, whenever i input it on alteryx the format changes. Substring does not help because columns are not straight.

I am giving you an example of how the primary text sap file looks and how it is in alteryx. 

My problem is that i cannot make them in particular columns. 

Thanks everyone,

[ChrisTX]

@nveliv the workflow I posted only uses one simple RegEx:

REGEX_Replace([Field_1], "([\t]+)", "\t")

//replace 2 or more tabs with one tab

Chris