How to import huge txt file with comma delimiter and new line delimiter vertical bar?

[slobo]

I'm having issue with importing huge txt file where delimiter is comma and there is also newline delimiter which is vertical bar.

I've tried to import with \0 delimiter so I could separate everything after with Text to tool but the error I'm receiving is that Input tool is unable to import because number of fields is greater than 16M fields. 

What could I do? Thanks.

[slobo]

Thanks, but I receive error "Error: Input Data (1): Record #1: Fields must be smaller than 16M" when I apply this on original file. The sample I provided you is just one tiny part of the file. 

[binuacs]

@slobo Are you able to run the workflow with the sample file you provided?

[slobo]

Yes, with the sample I could.