Shell Programming and Scripting

I have fixed width source file data look like this,

J510111112222
J5102ABCD
J510133334444
J5102EFGH

I want to make this like

11112222J510111112222
11112222J5102ABCD
33334444J510133334444
33334444J5102EFGH

Bolded is the record type.
Thanks for help.

What have you tried?

---------- Post updated at 10:48 AM ---------- Previous update was at 10:42 AM ----------

Try...

Code:

awk '{s=substr($0,6,length($0));print s$0;getline; print s$0}' inputfile

Thanks for ur reply...
but it is not working...
this is the original data

F51010141TK1070000483L4058S462 34329094 0232384840 381892 182 5690
F51020141FIRST CLEARING, LLC A/C 3432-9094
F51030141JOHAN HOLMQVIST YVSTANGSVAGEN 6
F51040141VALBO 81892 SWEDEN AIRMAIL 000000000
F51090141 0000 0
F51010141TK1070000443L4058T155 86374984 0232384840 4 182 5690
F51020141FIRST CLEARING, LLC A/C 8637-4984
F51030141CONFIDENTIAL & CONFIDENTIAL JT TEN
F510401412801 MARKET STREET SAINT LOUIS MO 63103



This is wt am getting
34329094 0232384840 381892 182 F51010141TK1070000483L4058S462 34329094 0232384840 381892 182 5690
34329094 0232384840 381892 182 F51020141FIRST CLEARING, LLC A/C 3432-9094
YVSTANGSVAGEN 6F51030141JOHAN HOLMQVIST YVSTANGSVAGEN 6
YVSTANGSVAGEN 6F51040141VALBO 81892 SWEDEN AIRMAIL 000000000
0000 0F51090141 0000 0
0000 0F51010141TK1070000443L4058T155 86374984 0232384840 4 182 5690
A/C 8637-4984F51020141FIRST CLEARING, LLC A/C 8637-4984
A/C 8637-4984F51030141CONFIDENTIAL & CONFIDENTIAL JT TEN
SAINT LOUIS MO 63103F510401412801 MARKET STREET SAINT LOUIS MO 63103
SAINT LOUIS MO 63103

I get this....and I believe this is what you wanted earlier... Please share the detailed requirement.

Code:

0141TK1070000483L4058S462 34329094 0232384840 381892 182 5690F51010141TK1070000483L4058S462 34329094 0232384840 381892 182 5690
0141TK1070000483L4058S462 34329094 0232384840 381892 182 5690F51020141FIRST CLEARING, LLC A/C 3432-9094
0141JOHAN HOLMQVIST YVSTANGSVAGEN 6F51030141JOHAN HOLMQVIST YVSTANGSVAGEN 6
0141JOHAN HOLMQVIST YVSTANGSVAGEN 6F51040141VALBO 81892 SWEDEN AIRMAIL 000000000
0141 0000 0F51090141 0000 0
0141 0000 0F51010141TK1070000443L4058T155 86374984 0232384840 4 182 5690
0141FIRST CLEARING, LLC A/C 8637-4984F51020141FIRST CLEARING, LLC A/C 8637-4984
0141FIRST CLEARING, LLC A/C 8637-4984F51030141CONFIDENTIAL & CONFIDENTIAL JT TEN
01412801 MARKET STREET SAINT LOUIS MO 63103F510401412801 MARKET STREET SAINT LOUIS MO 63103
01412801 MARKET STREET SAINT LOUIS MO 63103

How would I know you have more than just 01, 02 record type and you still have not shared the output you want and on what basis, it should be generated. A detailed requirement will help you and us more.

I have this data now,(Bolded is the primary key for each set and I want that to be included on the corresponding consecutive rows)

F51010141TK1070000483L4058S462 34329094 0232384840 381892 182 5690
F51020141FIRST CLEARING, LLC A/C 3432-9094
F51030141JOHAN HOLMQVIST YVSTANGSVAGEN 6
F51040141VALBO 81892 SWEDEN AIRMAIL 000000000
F51090141 0000 0
F51010141TK1070000443L4058T155 86374984 0232384840 4 182 5690
F51020141FIRST CLEARING, LLC A/C 8637-4984
F51030141CONFIDENTIAL & CONFIDENTIAL JT TEN
F510401412801 MARKET STREET SAINT LOUIS MO 63103

and I wanted it to be

A4058S462 34329094 F51010141TK1070000483A4058S462 34329094 0232384840 381892 182 5690
A4058S462 34329094 F51020141FIRST CLEARING, LLC A/C 3432-9094
A4058S462 34329094 F51030141JOHAN HOLMQVIST YVSTANGSVAGEN 6
A4058S462 34329094 F51040141VALBO 81892 SWEDEN AIRMAIL 000000000
A4058S462 34329094 F51090141 0000 0
L4058T155 86374984 F51010141TK1070000443L4058T155 86374984 0232384840 4 182 5690
L4058T155 86374984 F51020141FIRST CLEARING, LLC A/C 8637-4984
L4058T155 86374984 F51030141CONFIDENTIAL & CONFIDENTIAL JT TEN
L4058T155 86374984 F510401412801 MARKET STREET SAINT LOUIS MO 63103

Thanks

---------- Post updated at 02:29 AM ---------- Previous update was at 02:23 AM ----------

F51010141TK1070000483L4058S462 34329094 0232384840 381892 182 5690
F51020141FIRST CLEARING, LLC A/C 3432-9094
F51030141JOHAN HOLMQVIST YVSTANGSVAGEN 6
F51040141VALBO 81892 SWEDEN AIRMAIL 000000000
F51090141 0000 0
F51010141TK1070000443L4058T155 86374984 0232384840 4 182 5690
F51020141FIRST CLEARING, LLC A/C 8637-4984
F51030141CONFIDENTIAL & CONFIDENTIAL JT TEN
F510401412801 MARKET STREET SAINT LOUIS MO 63103

Bolded is the record type, like wise each set mite have 01 to 12...so I have to append the primary key as mentioned earlier till I reach next 01 to 12...

I am again confused, in the first record, key changes from L to A... but not the second time...
And where the code that you have tried?

oh ...sorry ...it is not changing from L to A ..it is A only...

Dude,

lemme explain in simple form, data looks like this,

F5101xxxxA4058S462 34329094
F5102
F5108 asdasd
F5101yyyyL4058T155 86374984
F5104
F5112 sdsd

Pink color is one set and green is another set.
Now i want the primary key to be added like,
A4058S462 34329094 F5101xxxxA4058S462 34329094
A4058S462 34329094 F5102
A4058S462 34329094 F5108 asdasd
L4058T155 86374984 F5101yyyyL4058T155 86374984
L4058T155 86374984 F5104
L4058T155 86374984 F5112 sdsd

The actual position of primary key is 22-30 & 32-51...it is fixed width file.
Thanks