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 / / / / / / / / /
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.
Have you thought replacing the / with ,
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |