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 303033940 by cemokam65 on Monday 15th of April 2019 02:35:52 AM
Old 04-15-2019
Above the solution by Rudic I just need one further step. My files like ;

Code:
ls -1rt DVA*
DVA.BPNE04.M.DELJIT101621
DVA.BPNE04.M.DELJIT101622
DVA.BPNE04.M.DELJIT101623
DVA.BPNE04.M.DELJIT101624
DVA.BPNE04.M.DELJIT101625
DVA.BPNE04.M.DELJIT101626
DVA.BPNE04.M.DELJIT101627
DVA.BPNE04.M.DELJIT101628
DVA.BPNE04.M.DELJIT101629
DVA.BPNE04.M.DELJIT101630
DVA.BPNE04.M.DELJIT101631
DVA.BPNE04.M.DELJIT101632
DVA.BPNE04.M.DELJIT101633
DVA.BPNE04.M.DELJIT101634
DVA.BPNE04.M.DELJIT101635
DVA.BPNE04.M.DELJIT101636
DVA.BPNE04.M.DELJIT101637
DVA.BPNE04.M.DELJIT101638
DVA.BPNE04.M.DELJIT101639
DVA.BPNE04.M.DELJIT101640
DVA.BPNE04.M.DELJIT101641
DVA.BPNE04.M.DELJIT101642
DVA.BPNE04.M.DELJIT101643
DVA.BPNE04.M.DELJIT101644
DVA.BPNE04.M.DELJIT101645
DVA.BPNE04.M.DELJIT101646
DVA.BPNE04.M.DELJIT101647
DVA.BPNE04.M.DELJIT101648
DVA.BPNE04.M.DELJIT101649

And I can get the records with command

Code:
ls -1rt DVA*|while read line
do
awk '/^GIR/ {GN = $0}; /^LIN/ {LN = $0} /^QTY/ {print GN, LN, $0}' $line >>$tarih_report1.txt
done

My tarih_report1.txt is like;
Code:
cat tarih_report1.txt
GIR+4+0018C-0376:AN++JQ:AT' LIN+++33.25480-5715:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++33.25480-5716:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++33.25480-5718:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++36.25480-5826:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++36.25480-5829:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++36.25480-5830:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++36.25480-5831:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++36.25480-5833:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++36.25480-5834:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++36.25480-5835:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++36.25480-5836:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++36.25480-5837:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++36.25480-5839:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++36.25480-6913:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++83.25480-5006:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++83.25480-5010:IN' QTY+131:1:C62'
GIR+4+0018C-0376:AN++JQ:AT' LIN+++83.25480-5026:IN' QTY+131:1:C62'
GIR+4+0018C-0373:AN++JR:AT' LIN+++36.25480-5649:IN' QTY+131:4:C62'
GIR+4+0012C-0613:AN++JR:AT' LIN+++36.25480-5649:IN' QTY+131:3:C62'
GIR+4+0018C-0374:AN++JR:AT' LIN+++36.25480-5649:IN' QTY+131:4:C62'
GIR+4+0012C-0614:AN++JR:AT' LIN+++36.25480-5649:IN' QTY+131:3:C62'
GIR+4+0012C-0615:AN++JR:AT' LIN+++36.25480-5649:IN' QTY+131:3:C62'

I just want to also add file names in every end of my record like as ;(Of course the "file names" have to match with their's records)
Code:
GIR+4+0018C-0376:AN++JQ:AT' LIN+++33.25480-5715:IN' QTY+131:1:C62'DVA.BPNE04.M.DELJIT101621
GIR+4+0018C-0376:AN++JQ:AT' LIN+++33.25480-5716:IN' QTY+131:1:C62'DVA.BPNE04.M.DELJIT101780
GIR+4+0018C-0376:AN++JQ:AT' LIN+++33.25480-5718:IN' QTY+131:1:C62'DVA.BPNE04.M.DELJIT101312
GIR+4+0018C-0376:AN++JQ:AT' LIN+++36.25480-5826:IN' QTY+131:1:C62'DVA.BPNE04.M.DELJIT102190

Last edited by rbatte1; 04-15-2019 at 10:53 AM.. Reason: Changed ICODE tags to CODE tags
 

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 07:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy