Convert Txt data to structured data

Question

Hi Team

I am new to convert .txt files to proper data. Could you please help me out to convert unstructured data to structure data.

I am attaching required txt files to convert - please provide me the logic on how to convert those ? - Thanks in advance.

Tech.txt

EOD.txt

Vishwak · Answer

Thanks, i am unable to open your solution  workflow due to version issue - could you please provide me the screenshot of what is the exact code used in below both the tools ?,Thanks.

binu_acs · Answer

@Vishwak these files are fixed length, so to split the fields you can use the same excel text to column option here. I split the first file with a fixed field length

Split_Text_200323.yxzp