Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

retrieve tags from source files and append in i/p

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting retrieve tags from source files and append in i/p
# 1  
Old 07-06-2009
retrieve tags from source files and append in i/p
My source input file constitutes the following .
I need to retrieve the tags “ BUY / SELL “ from my input and append at the end of the input lines after them .. Like I want to read the tag buy and append buy after the next 6 line before the tag SELL . Lines can be more aswell . Similartly read the SELL tag and append the tag at the end of the 7 lines after SELL
------

INPUT
=====
30/06/2009,NORMAL,ALL,ALL


BUY

1,CBLO/020709,T+0,30/06/2009,100.00,3.00,999835643.46,200906300000422,-, 15:04:42
2,CBLO/020709,T+0,30/06/2009,100.00,3.01,999835095.69,200906300000421,-, 15:04:42
3,CBLO/020709,T+0,30/06/2009,10.00,2.90,99984112.11,200906300000296,-, 13:32:34
4,CBLO/020709,T+0,30/06/2009,100.00,2.90,999841121.14,200906300000295,-, 13:32:34
5,CBLO/020709,T+0,30/06/2009,50.00,2.90,499920560.57,200906300000294,-, 13:32:34
6,CBLO/020709,T+0,30/06/2009,30.00,2.91,299952172.01,200906300000293,-, 13:32:34

SELL

1,CBLO/020709,T+0,30/06/2009,40.00,3.24,399928998.91,200906300000038,-, 09:47:22
2,CBLO/020709,T+0,30/06/2009,50.00,3.24,499911248.63,200906300000037,-, 09:47:22
3,CBLO/020709,T+0,30/06/2009,10.00,3.24,99982249.73,200906300000036,-, 09:47:22
4,CBLO/020709,T+0,30/06/2009,100.00,3.25,999821949.52,200906300000024,-, 09:31:09
5,CBLO/020709,T+0,30/06/2009,100.00,3.25,999821949.52,200906300000023,-, 09:31:09
6,CBLO/020709,T+0,30/06/2009,100.00,3.10,999830165.83,200906300000007,-, 09:11:55
7,CBLO/020709,T+0,30/06/2009,200.00,3.10,1999660331.67,200906300000006,-, 09:11:49
8,CBLO/020709,T+0,30/06/2009,200.00,3.05,1999665809.28,200906300000002,-, 09:11:28

390.00,800.00

3899368704.98,7998622703.09


====================================

OUTPUT
======
1,CBLO/020709,T+0,30/06/2009,100.00,3.00,999835643.46,200906300000422,-, 15:04:42,BUY
2,CBLO/020709,T+0,30/06/2009,100.00,3.01,999835095.69,200906300000421,-, 15:04:42,BUY
3,CBLO/020709,T+0,30/06/2009,10.00,2.90,99984112.11,200906300000296,-, 13:32:34,BUY
4,CBLO/020709,T+0,30/06/2009,100.00,2.90,999841121.14,200906300000295,-, 13:32:34,BUY
5,CBLO/020709,T+0,30/06/2009,50.00,2.90,499920560.57,200906300000294,-, 13:32:34,BUY
6,CBLO/020709,T+0,30/06/2009,30.00,2.91,299952172.01,200906300000293,-, 13:32:34,BUY
1,CBLO/020709,T+0,30/06/2009,40.00,3.24,399928998.91,200906300000038,-, 09:47:22,SELL
2,CBLO/020709,T+0,30/06/2009,50.00,3.24,499911248.63,200906300000037,-, 09:47:22,SELL
3,CBLO/020709,T+0,30/06/2009,10.00,3.24,99982249.73,200906300000036,-, 09:47:22,SELL
4,CBLO/020709,T+0,30/06/2009,100.00,3.25,999821949.52,200906300000024,-, 09:31:09,SELL
5,CBLO/020709,T+0,30/06/2009,100.00,3.25,999821949.52,200906300000023,-, 09:31:09,SELL
6,CBLO/020709,T+0,30/06/2009,100.00,3.10,999830165.83,200906300000007,-, 09:11:55,SELL
7,CBLO/020709,T+0,30/06/2009,200.00,3.10,1999660331.67,200906300000006,-, 09:11:49,SELL
8,CBLO/020709,T+0,30/06/2009,200.00,3.05,1999665809.28,200906300000002,-, 09:11:28,SELL
# 2  
Old 07-06-2009
Code:
awk -F, '$1 ~ /^BUY$|^SELL$/ {a=$1; next} !/^$/ && NF==10 {print $0","a}' infile

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Append string to all the files inside a directory excluding subdirectories and .zip files

Hii, Could someone help me to append string to the starting of all the filenames inside a directory but it should exclude .zip files and subdirectories. Eg. file1: test1.log file2: test2.log file3 test.zip After running the script file1: string_test1.log file2: string_test2.log file3:... (4 Replies)
Discussion started by: Ravi Kishore
4 Replies

2. Shell Programming and Scripting

Unzip all the files with subdirectories present and append a part of string from the main .zip files

Hi frnds, My requirement is I have a zip file with name say eg: test_ABC_UH_ccde2a_awdeaea_20150422.zip within that there are subdirectories on each directory we again have .zip files and in that we have files like mama20150422.gz and so on. Iam in need of a bash script so that it unzips... (0 Replies)
Discussion started by: Ravi Kishore
0 Replies

3. Shell Programming and Scripting

Using shell script to compare files and retrieve connections

Hello, I want to use shell script to generate network files (I tried with python but its taking too long). I have a list of nodes: node.txt LOC_Os11g37970 LOC_Os01g07760 LOC_Os03g19480 LOC_Os11g45740 LOC_Os06g08290 LOC_Os07g02800 I have an edge-list as well: edge.txt Source_node ... (2 Replies)
Discussion started by: Sanchari
2 Replies

4. Shell Programming and Scripting

Compare columns of two files and retrieve data

Hi guys, I need your help. I have two files: file1 1 3 5 file2 1,XX 2,AA 3,BB 4,CC 5,DD I would like to compare the first column and where they are equal to write that output in a new file: 1,XX 3,BB (7 Replies)
Discussion started by: apenkov
7 Replies

5. Shell Programming and Scripting

How to retrieve the latest files from the directory.?

hi, i have some file in a directory say p1.txt.201305051200.lst p1.txt.201305051300.lst p1.txt.201306051200.lst p1.txt.201306051300.lst p2.txt.201306051200.lst p2.txt.201306051300.lst i am using p* pattern to retrieve these file ls -1 p* the files in red color are the latest... (7 Replies)
Discussion started by: Little
7 Replies

6. Shell Programming and Scripting

awk to retrieve the particular value from a same list of xml tags

Hi All, I have the following code in one of my xml file: <com:parameter> <com:name>secretKey</com:name> <com:value>31XA874821172E89B00B1C</com:value> </com:parameter> <com:parameter> <com:name>tryDisinfect</com:name> <com:value>false</com:value> </com:parameter> <com:parameter>... (4 Replies)
Discussion started by: mjavalkar
4 Replies

7. Shell Programming and Scripting

Help to retrieve data from two files matching a string

Hello Experts, I have come back to this forum after a while now, since require a better way to get my result.. My query is as below.. I have 3 files -- 1 Input file, 2 Data files .. Based on the input file, data has to be retreived matching from two files which has one common key.. For EX:... (4 Replies)
Discussion started by: shaliniyadav
4 Replies

8. Shell Programming and Scripting

How to retrieve value from xml tags

hello, I have a file that have lines that contains xml tags. for each line, i want to retrieve the value from the following xml tags and output it to another file with the values only, comma seperated. what is the best way to do this? again, the string is all in 1 line one, though it has many... (9 Replies)
Discussion started by: davidsouk
9 Replies

9. Shell Programming and Scripting

How to retrieve all the linked script files/ctl files/sql files?

Hi I am going to migrate our datawarehouse system from HP Tru 64 Unix to the Red Hat Linux. Inside the box, it is running around 40 cron jobs; inside each cron job, it is calling other shell script files, and the shell script files may again call other shell script files or ctl files(for... (1 Reply)
Discussion started by: franksubramania
1 Replies

10. UNIX for Dummies Questions & Answers

Any way to retrieve deleted files?

:eek: I accidently removed some files using 'rm'. Is there any way to retrieve these files if they were deleted through 'rm'? (1 Reply)
Discussion started by: orahi001
1 Replies
Login or Register to Ask a Question