How to get some data in the file?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to get some data in the file?
# 8  
Old 01-03-2013
Code:
awk '{if ($0~"Rejected") a=1}0 {print}a' fromfile > tofile

This User Gave Thanks to Jotne For This Post:
# 9  
Old 01-03-2013
When i am using below commad
Code:
awk '{if ($0~"Rejected") a=1}0 {print}a' fromfile > tofile

I got the error like this

Code:
awk: syntax error near line 1
awk: illegal statement near line 1
awk: syntax error near line 1
awk: bailing out near line 1


Last edited by Scrutinizer; 01-03-2013 at 06:22 AM.. Reason: code tags
# 10  
Old 01-03-2013
On Solaris < version 11 use /usr/xpg4/bin/awk rather than awk
# 11  
Old 01-03-2013
Previously i used awk command. that is working fine.

---------- Post updated at 05:46 AM ---------- Previous update was at 05:36 AM ----------

Rejected is inbetween the line.

Code:
Record 1632: Rejected - Error on table NOR_DATA, column COMPANY_NUM.
 ORA-01722: invalid number

Is this code
Code:
awk '{if ($0~"Rejected") a=1}0 {print}a' fromfile > tofile

works fine or not?

Last edited by Scrutinizer; 01-03-2013 at 07:47 AM.. Reason: code tags
# 12  
Old 01-03-2013
On Ubuntu this line does work fine.
# 13  
Old 01-03-2013
It could be shortened a little:
Code:
awk '/Rejected/{p=1}p' file

or
Code:
awk '/Rejected/,0' file

or
Code:
sed -n '/Rejected/,$p' file

# 14  
Old 01-03-2013
This I understand:
Code:
awk '/Rejected/{p=1}p' file

Since P is 0, no line is printed before it find Rejected and sets p=1

But how does this work:
Code:
awk '/Rejected/,0' file

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

In PErl script: need to read the data one file and generate multiple files based on the data

We have the data looks like below in a log file. I want to generat files based on the string between two hash(#) symbol like below Source: #ext1#test1.tale2 drop #ext1#test11.tale21 drop #ext1#test123.tale21 drop #ext2#test1.tale21 drop #ext2#test12.tale21 drop #ext3#test11.tale21 drop... (5 Replies)
Discussion started by: Sanjeev G
5 Replies

2. Shell Programming and Scripting

awk --> math-operation in data-record and joining with second file data

Hi! I have a pretty complex job - at least for me! i have two csv-files with meassurement-data: fileA ...... (2 Replies)
Discussion started by: IMPe
2 Replies

3. Shell Programming and Scripting

Replace data of a file with data from another file using shell scripting.

Dears, I'm new to shell scripting and i was wondering if you can help me with following matter. I have a file containing 400,000 records. The file contains two columns like: 00611291,0270404000005453 25262597,1580401000016155 25779812,1700403000001786 00388934,1200408000000880... (1 Reply)
Discussion started by: paniklas
1 Replies

4. Shell Programming and Scripting

Extract header data from one file and combine it with data from another file

Hi, Great minds, I have some files, in fact header files, of CTD profiler, I tried a lot C programming, could not get output as I was expected, because my programming skills are very poor, finally, joined unix forum with the hope that, I may get what I want, from you people, Here I have attached... (17 Replies)
Discussion started by: nex_asp
17 Replies

5. Shell Programming and Scripting

Generate tabular data based on a column value from an existing data file

Hi, I have a data file with : 01/28/2012,1,1,98995 01/28/2012,1,2,7195 01/29/2012,1,1,98995 01/29/2012,1,2,7195 01/30/2012,1,1,98896 01/30/2012,1,2,7083 01/31/2012,1,1,98896 01/31/2012,1,2,7083 02/01/2012,1,1,98896 02/01/2012,1,2,7083 02/02/2012,1,1,98899 02/02/2012,1,2,7083 I... (1 Reply)
Discussion started by: himanish
1 Replies

6. UNIX for Dummies Questions & Answers

Mapping a data in a file and delete line in source file if data does not exist.

Hi Guys, Please help me with my problem here: I have a source file: 1212 23232 343434 ASAS1 4 3212 23232 343434 ASAS2 4 3234 23232 343434 QWQW1 4 1134 23232 343434 QWQW2 4 3212 23232 343434 QWQW3 4 and a mapping... (4 Replies)
Discussion started by: kokoro
4 Replies

7. UNIX for Dummies Questions & Answers

How to get data only inside polygon created by points which is part of whole data from file?

hiii, Help me out..i have a huge set of data stored in a file.This file has has 2 columns which is latitude & longitude of a region. Now i have a program which asks for the number of points & based on this number it asks the user to enter that latitude & longitude values which are in the same... (7 Replies)
Discussion started by: reva
7 Replies

8. Shell Programming and Scripting

Find and replace data in text file with data in same file

OK I will do my best to explain what I need help with. I am trying to format an ldif file so I can import it into Oracle oid. I need the file to look like this example. Keep in mind there are 3000 of these in the file. changetype: modify replace: userpassword dn:... (0 Replies)
Discussion started by: timothyha22
0 Replies

9. Shell Programming and Scripting

Using loop reading a file,retrieving data from data base.

Hi All, I am having trouble through, I am reading the input from tab delimited file containing several records, e.g. line1 field1 field2 field3 so on.. line2 field1 field2 field3 so on.. .. .. on the basis of certain fields for each record in input file, I have to retrieve... (1 Reply)
Discussion started by: Sonu4lov
1 Replies
Login or Register to Ask a Question