Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help text manipulation
Top Forums Shell Programming and Scripting Help text manipulation Post 303032159 by cemokam65 on Wednesday 13th of March 2019 02:29:56 AM
Old 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

Text Manipulation.

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

text manipulation

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

Help with text manipulation

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

Text Manipulation

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

[HELP] Text manipulation... [HELP]

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

text manipulation help

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

Text Manipulation Help

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

Text manipulation help

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

Text manipulation

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

Text manipulation help

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
All times are GMT -4. The time now is 10:05 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy