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! 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.
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 |
@flying008 yes this looks good. would you be able to attach the workbook?