Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk help string capture

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk help string capture
# 1  
Old 12-07-2013
awk help string capture
Dear All

My input file as under. From it I want op fine as mention below. Kindly help. I use below code but not help.

code:
Code:
awk -F"  " '{print $2}'

ip file:
Code:
"BSCJNGR_IPA17_C" 030 131207 1305 RXOCF-353 PBD011_BGIL   BOTH AC FAULTY
"BSCJNGR_IPA17_C" 991 131207 1637 RXOCF-224 NAV001_BGIL   SITE ON BATTERY
"BSCJNGR_IPA17_C" 150 131207 1704 RXOCF-105 GKA001_BGIL   SITE ON BATTERY RECTIFIRE FAIL
"BSCJNGR_IPA17_C" 276 131207 1742 RXOCF-78 KEN001_BGIL   SITE ON BATTERY RECTIFIRE FAIL LOW BATTERY VOLTAGE BOTH AC FAULTY
"BSCJNGR_IPA17_C" 290 131207 1746 RXOCF-67 JAM034_BGIL   MAINS FAIL
"BSCJUN1_IPA17_C" 372 131207 1320 RXOCF-84 SPS001_BGIL   SITE ON BATTERY DG ON RECTIFIRE FAIL

op:
Code:
131207 1305  PBD011_BGIL   BOTH AC FAULTY
131207 1637  NAV001_BGIL   SITE ON BATTERY
131207 1704  GKA001_BGIL   SITE ON BATTERY RECTIFIRE FAIL
131207 1742 KEN001_BGIL   SITE ON BATTERY RECTIFIRE FAIL LOW BATTERY VOLTAGE BOTH AC FAULTY
131207 1746 JAM034_BGIL   MAINS FAIL
131207 1320 SPS001_BGIL   SITE ON BATTERY DG ON RECTIFIRE FAIL

# 2  
Old 12-07-2013
Try:
Code:
awk '{$1=$2=$5=x; $0=$0; $1=$1}1' file

Code:
awk '
  {
    $1=$2=$5=x  # empty fields 1, 2 and 5
    $0=$0       # recalculate the fields (and the number of fields)
    $1=$1       # recalculate the record, removing excess spacing (the new spacing becomes OFS, default is a single space)
  }
  1             # print the record
' file

# 3  
Old 12-12-2013
awk help string capture
Dear All

First code take space as delimiter and second one is given error.

Kindly suggest some another alternative.

Regards
Jaydeep
# 4  
Old 12-12-2013
Quote:
Originally Posted by jaydeep_sadaria
Dear All

First code take space as delimiter and second one is given error.

Kindly suggest some another alternative.

Regards
Jaydeep

show error as well, Scrutinizer's code works
# 5  
Old 12-12-2013
awk help string capture
Kindly find the error and result for 1st code as below.

Code:
jaydsada@ideauas23> cat g.txt
"BSCJNGR_IPA17_C" 030 131207 1305 RXOCF-353 PBD011_BGIL   BOTH AC FAULTY
"BSCJNGR_IPA17_C" 991 131207 1637 RXOCF-224 NAV001_BGIL   SITE ON BATTERY
"BSCJNGR_IPA17_C" 150 131207 1704 RXOCF-105 GKA001_BGIL   SITE ON BATTERY RECTIFIRE FAIL
"BSCJNGR_IPA17_C" 276 131207 1742 RXOCF-78 KEN001_BGIL   SITE ON BATTERY RECTIFIRE FAIL LOW BATTERY VOLTAGE BOTH AC FAULTY
"BSCJNGR_IPA17_C" 290 131207 1746 RXOCF-67 JAM034_BGIL   MAINS FAIL
"BSCJUN1_IPA17_C" 372 131207 1320 RXOCF-84 SPS001_BGIL   SITE ON BATTERY DG ON RECTIFIRE FAIL
jaydsada@ideauas23> awk -F"  " '{print $2}' g.txt
030
991
150
276
290
372
jaydsada@ideauas23> awk '{$1=$2=$5=x; $0=$0; $1=$1}1' g.txt
awk: syntax error near line 1
awk: bailing out near line 1
jaydsada@ideauas23>

Regards
Jaydeep Sadaria
# 6  
Old 12-12-2013
Are you on solaris? If so then try nawk
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk:String search more than one time and capture OP

Dear All During one of mine script developemnt i am stuch at one sub part. Requiremnt is as below kindly help me. IP file: 2015-02-28 10:10:15 AL M UtranCell UtranCell=RTE001X (unavailable) 2015-02-28 10:10:15 AL M UtranCell UtranCell=RTE001Y (unavailable) 2015-02-28 10:10:15 AL M... (6 Replies)
Discussion started by: jaydeep_sadaria
6 Replies

2. Shell Programming and Scripting

Script to capture string in a log file

Dear all, I have a log file to be analysed. this log file contains vaiours lines of code starting with date timestamp. if my search string is exception then that resepective log statement starting from the date is required. example: 2014/10/01 16:14:44.459|>=|E|X|19202496|2832|... (5 Replies)
Discussion started by: shravee
5 Replies

3. Shell Programming and Scripting

How to capture string below a line?

Hi, I need to collect IP address of all servers (more than 300). One way is put it in for loop and run nslookup for that servers list, but there are multiple fields in output. (tty/dev/pts/13): bash: 1011 > nslookup vplssor04 Server: 10.58.115.34 Address: 10.58.115.34#53 Name: ... (7 Replies)
Discussion started by: solaris_1977
7 Replies

4. Shell Programming and Scripting

String capture from ip file

Dear All From below mention input file I want op file as mention. Kindly help. IP file: "BSCGNR4_IPA17_C" 329 140119 0717 RXOCF-105 KJO001_BASC_NG AC FAULTY DG ON DOOR OPEN Needed OP: 140119 0717 KJO001_BASC_NG AC FAULTY DG ON DOOR OPEN Note that string mark in red as variable in... (3 Replies)
Discussion started by: jaydeep_sadaria
3 Replies

5. Shell Programming and Scripting

How to capture a string enclose by a pattern within a file?

Hi all, My file :test.txt just like this: ........................... From: 333:123<sip:88888888888@bbbb.com To: <sip:123456@aaaaa.com ......................... I want a script to capture the string between sip: & @ Expect output: 88888888888 123456 Please help! (4 Replies)
Discussion started by: Alex Li
4 Replies

6. Shell Programming and Scripting

Capture string contained on a line?

Hello All, I'm working on a script that runs the wget command on a list of IP Address in order to capture the data at that address' index.html. That part works fine to get the HTML code at that address but the data I'm trying to pull out is on a line containing a BUNCH of code for an HTML... (4 Replies)
Discussion started by: mrm5102
4 Replies

7. Shell Programming and Scripting

sed or awk command to replace a string pattern with another string based on position of this string

here is what i want to achieve... consider a file contains below contents. the file size is large about 60mb cat dump.sql INSERT INTO `table1` (`id`, `action`, `date`, `descrip`, `lastModified`) VALUES (1,'Change','2011-05-05 00:00:00','Account Updated','2012-02-10... (10 Replies)
Discussion started by: vivek d r
10 Replies

8. UNIX for Advanced & Expert Users

capture data from matched string/line

Hi, I have a query as follows : suppose I am matching a string in a file say "start from here" and I want to pick up 'n' number of lines () from the matched string. Is there any way to do that ? 1) going forward I want to do this for every match for the above string 2) or limit this to... (2 Replies)
Discussion started by: sumoka
2 Replies

9. Shell Programming and Scripting

Need to capture certain text from a string in a different file

Hi, I wanted to know how i could accomplish this in a script using ksh. Lets say there is a file called test.dat and it has a certain input like below : . . Hi = 56 Hi = 67 . . 1 record(s) selected Now i need to capture the numbers after the = sign and store them in a... (3 Replies)
Discussion started by: Siddarth
3 Replies

10. Shell Programming and Scripting

Need to capture the service name from tnsnames.ora and create connect string

ghkjkjoj (4 Replies)
Discussion started by: chetankelvin
4 Replies
Login or Register to Ask a Question