Hello,
I need some help creating an excel sheet from certain information in a .txt file.
I have attached the .txt file I am using.
Below is an example how I need it to look, but I need all data for all people in the .txt file.
SSN | PART NAME | BIRTH DATE | FUND | SOURCE | MARKET VALUE | SHARE BALANCE | COST BASIS | NET CONTRIBUTIONS | EARNINGS |
XXX-XX-XXXX | JOHN DOE | 01/01/1900 | 001488 | AAA | $22,097.81 | 250.2300 | $19,614.92 | $19,564.07 | $2,533.74 |
Hi @JacobGFMR Is this sample data? It looks like there's a lot of sensitive data you uploaded if not..
@Luke_C I have removed the txt file and added a new one. Thank you.
Ultimately, yes. But I need to read it from a .txt file first.
Hi @JacobGFMR ,
Find attached a workflow which gives excepted output from provided text file.
Was that what you wanted?