Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Converting grep to awk

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Converting grep to awk
# 22  
Old 05-25-2012
the ouptut will be the whole record. I need to find a match inside field 9, but will print the whole record when I find it.
# 23  
Old 05-25-2012
Could you post a sample?
# 24  
Old 05-25-2012
Code:
Field1|Field2|Field3|2012-01-25||Field6|Field7|Field8|000/C///run (c-ab123, US) jobs.|Field10|Field11|Field12
Field1|Field2|Field3|2012-01-25||Field6|Field7|Field8|000/C///run (c-ab123, 897) jobs.|Field10|Field11|Field12
Field1|Field2|Field3|3-13-12||Field6|Field7|Field8|000/C///pour  897//a-1234 LBG|Field10|Field11|Field12
Field1|Field2|Field3|3-13-12||Field6|Field7|Field8|000/C///pour  US//a-cdef LBG|Field10|Field11|Field12

Post 14 had ALL my sample records, but the ones with the "-" are the problematic ones. You guys have helped me with pretty much all the non "-" ones. Here is a snippet of the most common variations. I just can't provide live data so I have replaced most of it with scrubbed data. I used bold to help point out what exactly i'm trying to find. Hopefully that helps.
Last edited by dagamier; 05-25-2012 at 01:37 PM.. Reason: added bold for exact string i'm searching
# 25  
Old 05-25-2012
Try:
Code:
awk --posix -F\| '$9~/\([a-z]-[a-z]{2}[0-9]{3}, [A-Z0-9]{2,3}\)|[A-Z0-9]{2,3}\/\/[a-z]-[a-z0-9]{4}/' infile

This User Gave Thanks to Scrutinizer For This Post:
dagamier
# 26  
Old 05-25-2012
Quote:
Originally Posted by Scrutinizer
Try:
Code:
awk --posix -F\| '$9~/\([a-z]-[a-z]{2}[0-9]{3}, [A-Z0-9]{2,3}\)|[A-Z0-9]{2,3}\/\/[a-z]-[a-z0-9]{4}/' infile

You sir ARE DA MAN!! Now I can go fix all my other ones quickly.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Converting awk to perl

Hello. I'm currently teaching myself Perl and was trying to turn an awk code that I had written into Perl. I have gotten stuck on a particular part and a2p has not helped me at all. The task was to take a .csv file containing a name, assignment type, score and points possible and compute it into a... (1 Reply)
Discussion started by: Eric7giants
1 Replies

2. UNIX for Beginners Questions & Answers

Converting awk to perl

Hello. I'm trying to convert an awk script I wrote to perl (which I just started self-teaching). I tried the a2p command but I couldn't make sense of most of it. Here was the awk code: BEGIN{ FS = "," print "NAME\tLOW\tHIGH\tAVERAGE" a=0 } { if(a==0){ a+=1 (1 Reply)
Discussion started by: Eric7giants
1 Replies

3. Shell Programming and Scripting

Using awk for converting xml to txt

Hi, I have a xml script, I converted it to .txt with values comma seperated using awk function. But I want the output values should be inside double quotes My xml script (Workorders.xml) is shown like below: <?xml version="1.0" encoding="utf-8" ?> <scbm-extract version="3.3">... (8 Replies)
Discussion started by: Viswanatheee55
8 Replies

4. Shell Programming and Scripting

Converting shell/awk to ruby

any idea on how to get started with this: shell script: awk '/{/,/}/' ~/newservices.txt | while read line do BEGIN=$(echo "${line}" | egrep ":" | egrep "{") if ; then checkname=$(echo $line | awk -F":" '{print $1}' | sed 's_"__g') echo "{"... (1 Reply)
Discussion started by: SkySmart
1 Replies

5. Shell Programming and Scripting

Converting awk script from bash to csh

I have the following script set up and working properly in bash. It basically copies a set of lines which match "AS1100002" from one file and replaces the same lines in another file. awk -vN=AS1100002* 'NR==FNR { if($1 ~ N)K=$0; next } { if($1 in K) $0=K; print }' $datadir/file1... (7 Replies)
Discussion started by: ncwxpanther
7 Replies

6. Shell Programming and Scripting

awk - problems by converting date-format

Hi i try to change the date-format from DD/MM/YYYY into MM/DD/YY. Input-Data: ... 31/12/2013,23:40,198.00,6.20,2,2,2,1,11580.0,222 31/12/2013,23:50,209.00,7.30,2,2,3,0,4380.0 01/01/2014,00:00,205.90,8.30,2,2,3,1,9360.0,223 ... Output-Data should be: ...... (7 Replies)
Discussion started by: IMPe
7 Replies

7. Shell Programming and Scripting

Converting to matrix-like file using AWK

Hi, Needs for statistics, doing converting Here is a sample file Input : 1|A|17,94 1|B|22,59 1|C|56,93 2|A|63,71 2|C|23,92 5|B|19,49 5|C|67,58 expecting something like that Output : 1|A|17,94|B|22,59|C|56,93 2|A|63,71|B|0|C|23,92 5|A|0|B|19,49|C|67,58 (11 Replies)
Discussion started by: fastlane3000
11 Replies

8. Shell Programming and Scripting

Converting txt file into CSV using awk or sed

Hello folks I have a txt file of information about journal articles from different fields. I need to convert this information into a format that is easier for computers to manipulate for some research that I'm doing on how articles are cited. The file has some header information and then details... (8 Replies)
Discussion started by: ksk
8 Replies

9. UNIX for Dummies Questions & Answers

Converting HP-UX awk to Solaris

Hi, I am using awk in HP-UX to enter an encrypted entry of the password into /etc/passwd with success, this is the command I am using and it is working great. cat /tmp/passwd.gal.before|awk -F: -v gal_passwd="encrypted_password" '{OFS=":" ; print $1,gal_passwd,$3,$4,$5,$6,$7}' >... (3 Replies)
Discussion started by: galuzan
3 Replies

10. Shell Programming and Scripting

Converting a line into a list using awk or sed

Hello, I am trying to convert a line into a list using awk or sed. Line: 345 897 567 098 123 output: 345 897 567 098 123 thanks (7 Replies)
Discussion started by: smarones
7 Replies
Login or Register to Ask a Question