Convert txt file into a table format

[geeklarokcmie]

Attached the input txt file that needs to be converted into a table format as below:

FirstName	LastName	EmpID	EmailAddress	St	City	CostCenterMgrID	Type	Pay
Jane Ping	Doe	IDTR69	janepingdoe@alteryx.com	HK	Hong Kong	99999999999999IDTR18	Regular	Bi-weekly
Brad Sudan	Doe	IDTR19	sudan.doe@alteryx.com	IA	Iowa City	99999999999900IDTR69	Regular	Bi-weekly
Nick Lawry	Larr	IDTR83	nick.lawry@alteryx.com	IA	Iowa City	999999999999000IDTR83	Regular	Bi-weekly

Appreciate any help/suggestions if possible. Thanks

[binu_acs]

@geeklarokcmie one way of doing this

[geeklarokcmie]

@binu_acs Appreciate your prompt response. An important detail I missed out was I need to pull the latest file from a shared folder path (using directory as an input) and then extract the data using dynamic input. In this case - the provided workflow is not working as expected. 

[binu_acs · Accepted solution]

@geeklarokcmie update your dynamic input tool settings like below, updated workflow attached

[geeklarokcmie]

@binu_acs Brilliant! That worked like magic. Thank you so much. :)