Certain Information from .TXT File to Excel

Question

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.

SSNPART NAMEBIRTH DATEFUNDSOURCEMARKET VALUESHARE BALANCECOST BASISNET CONTRIBUTIONSEARNINGSXXX-XX-XXXXJOHN DOE01/01/1900001488AAA$22,097.81250.2300$19,614.92$19,564.07$2,533.74

TXT FILE.txt

Emmanuel_G · Answer

Hi @JacobGFMR ,

Find attached a workflow which gives excepted output from provided text file.

Was that what you wanted?

Text file Processing.yxmd

JacobGFMR · Answer

Ultimately, yes. But I need to read it from a .txt file first.

JacobGFMR · Answer

@Luke_C I have removed the txt file and added a new one. Thank you.