03-13-2019
Help text manipulation
Hello Forum ,
I need a help about text manupulation. I have a text file and I have to manipulate this file. Let's say source.txt
Code :
source.txt
UNB+UNOC:3+O0013000005MAN MN RVS:91+0098006688:92+190304:2313+F004169241'
UNH+8146848+DELJIT:D:96A:UN'
BGM+307:::JIS_SYNCRO_FIRM+2019030423234101+9'
DTM+137:20190304:102'
DTM+67:201902140600:203'
RFF+AOW:90000032'
NAD+ST+F::92'
LOC+7+F-MOKB::92'
LOC+11+WARENEINGANG::92'
LOC+159+FJ0010::92'
SEQ+39+628601:4'
DTM+94:201902141041:203'
GIR+4+0012C-0294:AN++JM:AT'
LOC+54+F28022::92'
LIN+++33.25480-5827:IN'
IMD+F++:::WIAZKA ELEKTRYCZNA LADEN-HAST E4C-'
QTY+131:1:C62'
UNT+17+8146848'
UNH+8146849+DELJIT:D:96A:UN'
BGM+307:::JIS_SYNCRO_FIRM+2019030423234102+9'
DTM+137:20190304:102'
DTM+67:201902140600:203'
RFF+AOW:90000032'
NAD+ST+F::92'
LOC+7+F-MOKB::92'
LOC+11+WARENEINGANG::92'
LOC+159+FJ0010::92'
SEQ+39+628601:4'
DTM+94:201902141041:203'
GIR+4+0012C-0294:AN++JN:AT'
LOC+54+F28023::92'
LIN+++PZ.25480-5758:IN'
IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
QTY+131:1:C62'
UNT+17+8146849'
UNH+8146851+DELJIT:D:96A:UN'
BGM+307:::JIS_SYNCRO_FIRM+2019030423234103+9'
DTM+137:20190304:102'
DTM+67:201902140600:203'
RFF+AOW:90000032'
NAD+ST+F::92'
LOC+7+F-MOKB::92'
LOC+11+WARENEINGANG::92'
LOC+159+FJ0010::92'
SEQ+39+628601:4'
DTM+94:201902141041:203'
GIR+4+0012C-0294:AN++JQ:AT'
LOC+54+F28026::92'
LIN+++PZ.25480-5756:IN'
IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
QTY+131:1:C62'
LIN+++PZ.25480-5769:IN'
IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
QTY+131:1:C62'
LIN+++PZ.25480-5798:IN'
IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
QTY+131:1:C62'
LIN+++PZ.25480-5810:IN'
IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
QTY+131:1:C62'
UNT+26+8146851'
UNZ+3+F004169241'
Code :
cat -n source.txt
1 UNB+UNOC:3+O0013000005MAN MN RVS:91+0098006688:92+190304:2313+F004169241'
2 UNH+8146848+DELJIT:D:96A:UN'
3 BGM+307:::JIS_SYNCRO_FIRM+2019030423234101+9'
4 DTM+137:20190304:102'
5 DTM+67:201902140600:203'
6 RFF+AOW:90000032'
7 NAD+ST+F::92'
8 LOC+7+F-MOKB::92'
9 LOC+11+WARENEINGANG::92'
10 LOC+159+FJ0010::92'
11 SEQ+39+628601:4'
12 DTM+94:201902141041:203'
13 GIR+4+0012C-0294:AN++JM:AT'
14 LOC+54+F28022::92'
15 LIN+++33.25480-5827:IN'
16 IMD+F++:::WIAZKA ELEKTRYCZNA LADEN-HAST E4C-'
17 QTY+131:1:C62'
18 UNT+17+8146848'
19 UNH+8146849+DELJIT:D:96A:UN'
20 BGM+307:::JIS_SYNCRO_FIRM+2019030423234102+9'
21 DTM+137:20190304:102'
22 DTM+67:201902140600:203'
23 RFF+AOW:90000032'
24 NAD+ST+F::92'
25 LOC+7+F-MOKB::92'
26 LOC+11+WARENEINGANG::92'
27 LOC+159+FJ0010::92'
28 SEQ+39+628601:4'
29 DTM+94:201902141041:203'
30 GIR+4+0012C-0294:AN++JN:AT'
31 LOC+54+F28023::92'
32 LIN+++PZ.25480-5758:IN'
33 IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
34 QTY+131:1:C62'
35 UNT+17+8146849'
36 UNH+8146851+DELJIT:D:96A:UN'
37 BGM+307:::JIS_SYNCRO_FIRM+2019030423234103+9'
38 DTM+137:20190304:102'
39 DTM+67:201902140600:203'
40 RFF+AOW:90000032'
41 NAD+ST+F::92'
42 LOC+7+F-MOKB::92'
43 LOC+11+WARENEINGANG::92'
44 LOC+159+FJ0010::92'
45 SEQ+39+628601:4'
46 DTM+94:201902141041:203'
47 GIR+4+0012C-0294:AN++JQ:AT'
48 LOC+54+F28026::92'
49 LIN+++PZ.25480-5756:IN'
50 IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
51 QTY+131:1:C62'
52 LIN+++PZ.25480-5769:IN'
53 IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
54 QTY+131:1:C62'
55 LIN+++PZ.25480-5798:IN'
56 IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
57 QTY+131:1:C62'
58 LIN+++PZ.25480-5810:IN'
59 IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
60 QTY+131:1:C62'
61 UNT+26+8146851'
62 UNZ+3+F004169241'
I am interest in the records of between every "GIR" lines
Code :
catn -n source.txt|grep -i "GIR"
13 GIR+4+0012C-0294:AN++JM:AT'
30 GIR+4+0012C-0294:AN++JN:AT'
47 GIR+4+0012C-0294:AN++JQ:AT'
SO My final output will be;
Code :
GIR+4+0012C-0294:AN++JM:AT' LIN+++33.25480-5827:IN' QTY+131:1:C62'
GIR+4+0012C-0294:AN++JN:AT' LIN+++PZ.25480-5758:IN' QTY+131:1:C62'
GIR+4+0012C-0294:AN++JQ:AT' LIN+++PZ.25480-5756:IN' QTY+131:1:C62'
GIR+4+0012C-0294:AN++JQ:AT' LIN+++PZ.25480-5769:IN' QTY+131:1:C62'
GIR+4+0012C-0294:AN++JQ:AT' LIN+++PZ.25480-5798:IN' QTY+131:1:C62'
GIR+4+0012C-0294:AN++JQ:AT' LIN+++PZ.25480-5810:IN' QTY+131:1:C62'
I need LIN & QTY lines for each GIR lines. As above first GIR line starts at the line of 13 so through the second GIR (at line 40) There are lines LIN & QTY. I want to write out as GIR_NAME LIN QTY.
--- Post updated at 09:29 AM ---
Code :
source.txt
UNB+UNOC:3+O0013000005MAN MN RVS:91+0098006688:92+190304:2313+F004169241'
UNH+8146848+DELJIT:D:96A:UN'
BGM+307:::JIS_SYNCRO_FIRM+2019030423234101+9'
DTM+137:20190304:102'
DTM+67:201902140600:203'
RFF+AOW:90000032'
NAD+ST+F::92'
LOC+7+F-MOKB::92'
LOC+11+WARENEINGANG::92'
LOC+159+FJ0010::92'
SEQ+39+628601:4'
DTM+94:201902141041:203'
GIR+4+0012C-0294:AN++JM:AT'
LOC+54+F28022::92'
LIN+++33.25480-5827:IN'
IMD+F++:::WIAZKA ELEKTRYCZNA LADEN-HAST E4C-'
QTY+131:1:C62'
UNT+17+8146848'
UNH+8146849+DELJIT:D:96A:UN'
BGM+307:::JIS_SYNCRO_FIRM+2019030423234102+9'
DTM+137:20190304:102'
DTM+67:201902140600:203'
RFF+AOW:90000032'
NAD+ST+F::92'
LOC+7+F-MOKB::92'
LOC+11+WARENEINGANG::92'
LOC+159+FJ0010::92'
SEQ+39+628601:4'
DTM+94:201902141041:203'
GIR+4+0012C-0294:AN++JN:AT'
LOC+54+F28023::92'
LIN+++PZ.25480-5758:IN'
IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
QTY+131:1:C62'
UNT+17+8146849'
UNH+8146851+DELJIT:D:96A:UN'
BGM+307:::JIS_SYNCRO_FIRM+2019030423234103+9'
DTM+137:20190304:102'
DTM+67:201902140600:203'
RFF+AOW:90000032'
NAD+ST+F::92'
LOC+7+F-MOKB::92'
LOC+11+WARENEINGANG::92'
LOC+159+FJ0010::92'
SEQ+39+628601:4'
DTM+94:201902141041:203'
GIR+4+0012C-0294:AN++JQ:AT'
LOC+54+F28026::92'
LIN+++PZ.25480-5756:IN'
IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
QTY+131:1:C62'
LIN+++PZ.25480-5769:IN'
IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
QTY+131:1:C62'
LIN+++PZ.25480-5798:IN'
IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
QTY+131:1:C62'
LIN+++PZ.25480-5810:IN'
IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
QTY+131:1:C62'
UNT+26+8146851'
UNZ+3+F004169241'
Code :
cat -n source.txt
1 UNB+UNOC:3+O0013000005MAN MN RVS:91+0098006688:92+190304:2313+F004169241'
2 UNH+8146848+DELJIT:D:96A:UN'
3 BGM+307:::JIS_SYNCRO_FIRM+2019030423234101+9'
4 DTM+137:20190304:102'
5 DTM+67:201902140600:203'
6 RFF+AOW:90000032'
7 NAD+ST+F::92'
8 LOC+7+F-MOKB::92'
9 LOC+11+WARENEINGANG::92'
10 LOC+159+FJ0010::92'
11 SEQ+39+628601:4'
12 DTM+94:201902141041:203'
13 GIR+4+0012C-0294:AN++JM:AT'
14 LOC+54+F28022::92'
15 LIN+++33.25480-5827:IN'
16 IMD+F++:::WIAZKA ELEKTRYCZNA LADEN-HAST E4C-'
17 QTY+131:1:C62'
18 UNT+17+8146848'
19 UNH+8146849+DELJIT:D:96A:UN'
20 BGM+307:::JIS_SYNCRO_FIRM+2019030423234102+9'
21 DTM+137:20190304:102'
22 DTM+67:201902140600:203'
23 RFF+AOW:90000032'
24 NAD+ST+F::92'
25 LOC+7+F-MOKB::92'
26 LOC+11+WARENEINGANG::92'
27 LOC+159+FJ0010::92'
28 SEQ+39+628601:4'
29 DTM+94:201902141041:203'
30 GIR+4+0012C-0294:AN++JN:AT'
31 LOC+54+F28023::92'
32 LIN+++PZ.25480-5758:IN'
33 IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
34 QTY+131:1:C62'
35 UNT+17+8146849'
36 UNH+8146851+DELJIT:D:96A:UN'
37 BGM+307:::JIS_SYNCRO_FIRM+2019030423234103+9'
38 DTM+137:20190304:102'
39 DTM+67:201902140600:203'
40 RFF+AOW:90000032'
41 NAD+ST+F::92'
42 LOC+7+F-MOKB::92'
43 LOC+11+WARENEINGANG::92'
44 LOC+159+FJ0010::92'
45 SEQ+39+628601:4'
46 DTM+94:201902141041:203'
47 GIR+4+0012C-0294:AN++JQ:AT'
48 LOC+54+F28026::92'
49 LIN+++PZ.25480-5756:IN'
50 IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
51 QTY+131:1:C62'
52 LIN+++PZ.25480-5769:IN'
53 IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
54 QTY+131:1:C62'
55 LIN+++PZ.25480-5798:IN'
56 IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
57 QTY+131:1:C62'
58 LIN+++PZ.25480-5810:IN'
59 IMD+F++:::CZESC PROTOTYPOWA EL-LEITUNGSSATZ'
60 QTY+131:1:C62'
61 UNT+26+8146851'
62 UNZ+3+F004169241'
Code :
catn -n source.txt|grep -i "GIR"
13 GIR+4+0012C-0294:AN++JM:AT'
30 GIR+4+0012C-0294:AN++JN:AT'
47 GIR+4+0012C-0294:AN++JQ:AT
Code :
GIR+4+0012C-0294:AN++JM:AT' LIN+++33.25480-5827:IN' QTY+131:1:C62'
GIR+4+0012C-0294:AN++JN:AT' LIN+++PZ.25480-5758:IN' QTY+131:1:C62'
GIR+4+0012C-0294:AN++JQ:AT' LIN+++PZ.25480-5756:IN' QTY+131:1:C62'
GIR+4+0012C-0294:AN++JQ:AT' LIN+++PZ.25480-5769:IN' QTY+131:1:C62'
GIR+4+0012C-0294:AN++JQ:AT' LIN+++PZ.25480-5798:IN' QTY+131:1:C62'
GIR+4+0012C-0294:AN++JQ:AT' LIN+++PZ.25480-5810:IN' QTY+131:1:C62'
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I have only ever used awk and sed for basic requirements up until now.
I have had to break a log down for multiple purposes.
Using awk, sed and a date script. I am left with this:
(message id, time of msg attempt, message id, domain name, time of msg completion)
... (4 Replies)
Discussion started by: Icepick
4 Replies
2. UNIX for Dummies Questions & Answers
I am tryin to figure out how to extract interested text from file
example.txt
blah blah
blah a: child1
blah a: child2
blah b: parent1
blah blah
blah ....
blah a: child21
blah a: child22
blah a: child23
blah b: parent2
this kinda text repeats .. number of children is... (6 Replies)
Discussion started by: rajkishore
6 Replies
3. UNIX for Dummies Questions & Answers
Hi there,
I have some text files in unix format that processed by a program in windows, and when I open them with less or vi in linux, a warn for opening binary file is prompted, and as shown in vi, between every two characters there was inserted a "^@". How can I fix this. Plus, there are over... (2 Replies)
Discussion started by: dustinwang2003
2 Replies
4. UNIX for Dummies Questions & Answers
Greetings. Iīm a biologist and I donīt have mucho knowledge on Unix/Linux, but I need to use Cygwin to change some documents from a GenBank format to a FASTA format. GenBank format goes somthing like this:
LOCUS NM_013964 2568 bp mRNA linear PRI 26-APR-2009... (2 Replies)
Discussion started by: vanesa1230
2 Replies
5. Shell Programming and Scripting
I need to know how can I remove all word after comma on each line.
Like:
jjkj,iiuiui,ijlkjkij,ookoo
kijljlj,jhhkj,ijijkijkj,oijkijj
kjkljlkj,kjkjlkjlkj,opok,okop
to
jjkj,
kijljlj,
... (5 Replies)
Discussion started by: slutb3
5 Replies
6. UNIX for Dummies Questions & Answers
Hello again unix.com
How can I extract from a large file in format:
steve@aol.com steve hawkins Location of this member is bla bla bla
sun@hotmail.com Sun Ying This member is using browser bla bla bla
to another text in format:
steve@aol.com steve hawkins
sun@hotmail.com sun ying
... (5 Replies)
Discussion started by: galford
5 Replies
7. UNIX for Dummies Questions & Answers
Hello Unix.com,
I have a text in format:
john
sara
lee
How can I make it:
john:john
john:john1
john:john12
john:john123
sara:sara
sara:sara12
sara:sara123 and so on (2 Replies)
Discussion started by: galford
2 Replies
8. UNIX for Dummies Questions & Answers
Hello unix.com users,
I have a ip file (line-by-line). How can I delete the ips that keep repeating by mark XXX.XXX.XXX.* ... I want to erase only the lines that keep repeating more than 2 times.
Example:
1.2.3.1
1.2.3.2
1.2.3.3
I want to erase all ips blocks that are repeating by C... (1 Reply)
Discussion started by: galford
1 Replies
9. UNIX for Dummies Questions & Answers
i want to generate a list line-by-line of normal characters
using letters . for example :
dnds
gnos
mgod
pets
jnfp
etc...
i want to use all letters with all the posibilities
is there a script that can do this ? (3 Replies)
Discussion started by: suppliernr1
3 Replies
10. Shell Programming and Scripting
Hello again,
I have a problem manipulating a large text document and there is no way I could edit this document by hand.
Format is:
Address : XXXX N 37 Ave, Hollywood, FL, 33021
Phone: XXX3190XXX
Player: XXXXXX
Character: Jaramillo
DOB: June-14-1995
-----
Name: Alexandra
Ticket... (3 Replies)
Discussion started by: galford
3 Replies