Read in zip file (.txt file inside) , parse the columns help.

[wonka1234]

Hi,

I have two requirements.

1) Create new column headers, doesnt matter what they are called.

2) Parse the remaining data into separate fields.

it seems very hard to do this and make this readable.

Any tips or ideas on how to parse this correctly?

[flying008]

Hi, @wonka1234 

Please show you want output data table.

[wonka1234]

@flying008 hi! I want it delimited by tab or space between the obvious values.  Not as a pc right now so i cant show output.  Maybe in morning.

[flying008]

Hi, @wonka1234 

Maybe this is not your want if you clear show your mind.

Txt	1	2	3	4	5
T99|BAYERN2|NATHAN BAY|888-999-1234|200320230811111111111	T99	BAYERN2	NATHAN BAY	888-999-1234	200320230811111000000
T99|BAYERN2|JOB TEMPLATE|3486M04|NEW ACCT OFCR|XXX-XXX-XXXX	T99	BAYERN2	JOB TEMPLATE	3486M04	NEW ACCT OFCR|XXX-XXX-XXXX
T99|BAYERN2|FORBID PANEL|AI10|AIML	T99	BAYERN2	FORBID PANEL	AI10	AIML
T99|BAYERN2|FORBID PANEL|AI10|AIEM	T99	BAYERN2	FORBID PANEL	AI10	AIEM
T99|BAYERN2|FORBID PANEL|AI10|AIMA	T99	BAYERN2	FORBID PANEL	AI10	AIMA
T83|AABAYN2|PERMISSION/PARAMETERAP UPD MOP INFO	T83	AABAYN2	PERMISSION/PARAMETERAP UPD MOP INFO
T83|AABAYN2|PERMISSION/PARAMETERAP UPD PAYMT INFO	T83	AABAYN2	PERMISSION/PARAMETERAP UPD PAYMT INFO
T83|AABAYN2|PERMISSION/PARAMETERAP UPD SID INFO|Y	T83	AABAYN2	PERMISSION/PARAMETERAP UPD SID INFO	Y

[wonka1234]

@flying008  yes this looks good. would you be able to attach the workbook?