I am new (never used) and have v1.39.1
I have the following dataset that I need to create as an expanded fixed field length text dataset for additional processing. I also need to have things like " and $ removed in the process… can I generate the fixed field length file with this tool?
—begin—
Customer:,10415,Name:,456 Benefits,Account Type:,Open Item,
Balance,Document Number,Type,Date,Amount,Writeoff,Current,0 - 30 Days,31 - 60 Days,61 - 90 Days,91 - 180 Days,181 - 365 Days,365 and Over
INV000097201,SLS,9/1/2022,"$9,058.79 “,”$9,058.79 “,”$9,058.79 “,
INV000097720,SLS,10/1/2022,”$8,736.29 “,”$8,736.29 “,”$8,736.29 “,
Customer:,10481,Name:,12HourFlex,Account Type:,Open Item,
Balance,Document Number,Type,Date,Amount,Writeoff,Current,0 - 30 Days,31 - 60 Days,61 - 90 Days,91 - 180 Days,181 - 365 Days,365 and Over
PYMNT000065136,PMT,7/29/2022,($201.45),($201.45),
Customer:,10488,Name:,“3Z Benefits Solution, LLC”,Account Type:,Open Item,
Balance,Document Number,Type,Date,Amount,Writeoff,Current,0 - 30 Days,31 - 60 Days,61 - 90 Days,91 - 180 Days,181 - 365 Days,365 and Over
INV000097742,SLS,10/1/2022,”$1,260.00 “,”$1,260.00 “,”$1,260.00 ",
—end—