Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Create a formatted csv file from unstructured text file, by REGEX and/or Text To Column

pmumford
5 - Atom

Read txt file attached and write output excel or csv file.

Can this pattern be broken out into formatted fields, delimiters in original file is combination of spaces, tabs and back slash?

txt file sample:

0SSNCURINV 500BATCH X/
4FT01 12345025CIG40003272025/ USD / / / 039525G71089 / / / / / // / / / / / / / /// / / / / / / /
2ZBSZG 31/ 49.58 / / / / / / / 00011 / / D/104099 / / / / 226540 / / / /
2ZBSZG 40G71011.58 / / G719012360/ / / / / / / / //6200000 / / / / / / / / /
4FT01 12345025CIG40003272025/ USD / / / 032625G740391 / ME-3/2025 FITE TAX INSTAL/ / / // / / / / / / / /// / / / / / / /
2ZBSZG 31/ 741.00 / / / / / / *ME-3/2025 FITE TAX INSTALLMENT 00011 / / D/104564 / / / / 226541 / / / /
2ZBSZG 40G740371.00 / / / / / / ME-3/2025 FIRE TAX INSTALLMENT / / / / //2060050 / / 9800000 / / / / / /
4FT01 07772025CIG40003272025/ USD / / / 032625G7109 / ME-03/2025 FITE TAX INSTA/ / / // / / / / / / / /// / / / / / / /
2ZBSZG 32/ 3.00 / / / / / / *ME-03/2025 FIRE TAX INSTALLMENT 00011 / / D/104564 / / / / 226542 / / / /
2ZBSZG 40G7403.00 / / / / / / ME-03/2025 FIRE TAX INSTALLMENT / / / / //2060050 / / 9800000 / / / / / /
4FT01 88242025CIG40003272025/ USD / / / CVTRS-032425 / COLLTPUS INC -OMC10015026/ / / // / / / / / / / /// / / / / / / /
2ZBSZG 31/ 104884.50 / / / / / / *COVOTRUS INC -OMC10015076903 2026-2024 UW YR 00011 / / //106469 / / / / 226526 / / / /
2ZBSZG 40G500104514.50 / / / / / / COVOTRUS INC -OMC10015076903 2026-2024 UW YR / / / / //5220005 / / 1900500 / / / / / /
4FT01 06632025CIG40003272025/ USD / / / 00092 / / / / / // / / / / / / / /// / / / / / / /
2ZBSZG 31/ 9004.04 / / / / / / / 00011 / / //107015 / / / / 226545 / / / /
2ZBSZG 40G4075000.00 / / G200017355/ / / / / / / / //6051025 / / / / / / / / /
4FT01 03992025CIG40003272025/ USD / / / 1708999 / / / / / // / / / / / / / /// / / / / / / /
2ZBSZG 31/ 49.32 / / / / / / / 000130 / / //107161 / / / / 226397 / / / /
2ZBSZG 40G40743.35 / / G200158120/ / / / / / / / //6300030 / / / / / / / / /

2 REPLIES 2
caltang
17 - Castor
17 - Castor

What are you expecting...? We can format it but unless we know what your desired output looks like, we're shooting in the dark here.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
OTrieger
13 - Pulsar

@pmumford 

Have you thought replacing the / with ,

Labels
Top Solution Authors