Certain Information from .TXT File to Excel

[JacobGFMR]

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

[Luke_C]

Hi @JacobGFMR Is this sample data? It looks like there's a lot of sensitive data you uploaded if not.. 

[Emmanuel_G]

Hi @JacobGFMR ,

Do you want something like this ? ( Workflow attached )

[JacobGFMR]

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

[JacobGFMR]

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

[Emmanuel_G]

Hi @JacobGFMR ,

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

Was that what you wanted?