awk help string capture

Shell Programming and Scripting
1

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:

awk -F"  " '{print $2}'

ip file:

"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:

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

Try:

awk '{$1=$2=$5=x; $0=$0; $1=$1}1' file

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

Dear All

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

Kindly suggest some another alternative.

Regards
Jaydeep

4

show error as well, Scrutinizer's code works

5

Kindly find the error and result for 1st code as below.

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

Are you on solaris? If so then try nawk