Ricky White
asked on
How to break records from a single line of multiple records? VB.Net or C#
I have a file with multiple records entered on a single line without a record breaker as follows.
AAABUS6666666 01 AAAB,INC. 1105070522AAABUS9147930 21 0008060362Smith John 540 N.VIA VALVERDEAAABUS7777777 01 AAAB,INC. 1105070522AAABUS9147930 21 0008060362Carillo Dave 201 Verdugo AveAAABUS8888888 01 AAAB,INC. 1105070522AAABUS9147930 21 0008060362Stevenson Craig 540 N.VIA VALVERDE
I would like to break these records with a ; or any special character
Please advise how can this be accomplished in VB.Net.
The only thing that is unique and can indicate a record breaker is "01 AAAB,INC."
Each record is not fixed length.
AAABUS is repeated twice on each line.
After processing, the final output should look like(Please note the ; and line break):
AAABUS6666666 01 AAAB,INC. 1105070522AAABUS9147930 21 0008060362Smith John 540 N.VIA VALVERDE;
AAABUS7777777 01 AAAB,INC. 1105070522AAABUS9147930 21 0008060362Carillo Dave 201 Verdugo Ave;
AAABUS8888888 01 AAAB,INC. 1105070522AAABUS9147930 21 0008060362Stevenson Craig 600 N.Hollywood;
Thanks.
AAABUS6666666 01 AAAB,INC. 1105070522AAABUS9147930 21 0008060362Smith John 540 N.VIA VALVERDEAAABUS7777777 01 AAAB,INC. 1105070522AAABUS9147930 21 0008060362Carillo Dave 201 Verdugo AveAAABUS8888888 01 AAAB,INC. 1105070522AAABUS9147930 21 0008060362Stevenson Craig 540 N.VIA VALVERDE
I would like to break these records with a ; or any special character
Please advise how can this be accomplished in VB.Net.
The only thing that is unique and can indicate a record breaker is "01 AAAB,INC."
Each record is not fixed length.
AAABUS is repeated twice on each line.
After processing, the final output should look like(Please note the ; and line break):
AAABUS6666666 01 AAAB,INC. 1105070522AAABUS9147930 21 0008060362Smith John 540 N.VIA VALVERDE;
AAABUS7777777 01 AAAB,INC. 1105070522AAABUS9147930 21 0008060362Carillo Dave 201 Verdugo Ave;
AAABUS8888888 01 AAAB,INC. 1105070522AAABUS9147930 21 0008060362Stevenson Craig 600 N.Hollywood;
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER