awk - how to compare part of the string?

Login or Register to Ask a Question and Join Our Community

awk - how to compare part of the string?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting awk - how to compare part of the string?

10-11-2013

Registered User

49, 0

Join Date: Jun 2012

Last Activity: 17 March 2015, 8:17 AM EDT

Posts: 49

Thanks Given: 30

Thanked 0 Times in 0 Posts

awk - how to compare part of the string?

Need help for awk..
file will have comma separated numbers, I need check digits before 10 numbers eg ( 001)1234567890
Basically want to check country code of a mobile number.

eg:

Code:

abc,def,data, data,0011234567890, data,data

Script should be checking country code with 001, I will pass country code in a variable.
Thanks!

Last edited by radoulov; 10-11-2013 at 08:47 AM..

vegasluxor

View Public Profile for vegasluxor

Find all posts by vegasluxor

10-11-2013

Registered User

334, 87

Join Date: May 2011

Last Activity: 30 May 2018, 2:26 AM EDT

Posts: 334

Thanks Given: 39

Thanked 87 Times in 86 Posts

Code:

awk -F, -v c=001 'substr($5,0,3)==c' file

This will print the line if the first three numbers of the 5th field are 001.

This User Gave Thanks to Subbeh For This Post:

Subbeh

View Public Profile for Subbeh

Find all posts by Subbeh

10-11-2013

Registered User

49, 0

Join Date: Jun 2012

Last Activity: 17 March 2015, 8:17 AM EDT

Posts: 49

Thanks Given: 30

Thanked 0 Times in 0 Posts

Thanks!
But how do I find 3 digits before 10 digits from right ? Number could be greater or less than 10... if greater it might have leading multiple zeros.. So need to compare from the right side of the string.

eg: number 1231234567890
country (123)1234567890

eg: number 00000000121234567890
country 012

eg number 12345
country : nothing will be there to compare as number is not 10 digit

Please help !

Last edited by vegasluxor; 10-11-2013 at 09:05 AM..

vegasluxor

View Public Profile for vegasluxor

Find all posts by vegasluxor

10-11-2013

Registered User

334, 87

Join Date: May 2011

Last Activity: 30 May 2018, 2:26 AM EDT

Posts: 334

Thanks Given: 39

Thanked 87 Times in 86 Posts

try this:

Code:

awk -F, -v c=001 'substr($5,length($5)-12,3)==c' file

Subbeh

View Public Profile for Subbeh

Find all posts by Subbeh

10-14-2013

Registered User

49, 0

Join Date: Jun 2012

Last Activity: 17 March 2015, 8:17 AM EDT

Posts: 49

Thanks Given: 30

Thanked 0 Times in 0 Posts

Thanks a lot ! It worked !!!

vegasluxor

View Public Profile for vegasluxor

Find all posts by vegasluxor

10-14-2013

Registered User

2,977, 644

Join Date: Oct 2010

Last Activity: 14 September 2019, 1:15 PM EDT

Location: France

Posts: 2,977

Thanks Given: 88

Thanked 644 Times in 613 Posts

even shorter :

Code:

awk -F, -v c=001 '$5~c"..........$"' file

Note that this code does not check wheter the 10 characters that are on the right of c are digit or not , but neither does the code provided by Subbeh

ctsgnb

View Public Profile for ctsgnb

Find all posts by ctsgnb

10-14-2013

Registered User

1,119, 264

Join Date: Oct 2011

Last Activity: 14 August 2020, 12:53 PM EDT

Location: London, UK

Posts: 1,119

Thanks Given: 134

Thanked 264 Times in 247 Posts

Code:

$ cat file
abc,def,data, data,0011234567890, data,data
abc,def,data, data,00112345678901, data,data
abc,def,data, data,001123456789, data,data
abc,def,data, data,001123456789x, data,data
abc,def,data, data,0021234567890, data,data
$ awk -F, -v c=001 '$5~"^"c"[[:digit:]]{10}$"' file
abc,def,data, data,0011234567890, data,data

(GNU awk on cygwin)

Last edited by CarloM; 10-14-2013 at 01:40 PM.. Reason: better test data

CarloM

View Public Profile for CarloM

Find all posts by CarloM

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Concatenate a string and number and compare that with another string in awk script

I have below code inside my awk script if ( $0 ~ /SVC IN:/ ) { svc_in=substr( $0,23 , 3); if (msg_start == 1 && msg_end == 0) { msg_arr=$0; } } else if ( $0 ~ /^SVC OUT:/ ) { svc_out=substr( $0, 9, 3); if (msg_start == 1 && msg_end == 0) ...

2. Shell Programming and Scripting

Pass column number as variable to awk and compare with a string.

Hi All, I have a file test.txt. Content of test.txt : 1 vinay se 2 kumar sse 4 kishore tl I am extracting the content of file with below command. awk '$2 ~ "vinay" {print $0}' test.txt Now instead of hardcoding $2 is there any way pass $2 as variable and compare with a...

3. Shell Programming and Scripting

String compare using awk - what am I doing wrong?

Hi all, I was doing some string manipulation in my script and wanted to try using awk. However, I have been stuck with string compare. A simplified form of my conundrum is given below: The below prints expected result (prints "Completed because that is the second element"): $ echo...

4. Shell Programming and Scripting

awk: process a part of string, leaving others unchanged

Hello, I have a bunch of strings of the following format: 11.22.33.44.in-addr.arpa x.y.z. What I want to do is format each string in this way: 44.33.22.11 x.y.z i.e. the string conists of two columns, where delimiter is space. I need to output modified first column (delimiter inside...

5. Shell Programming and Scripting

awk if statement to evaluate string and compare

I have the following simplified code that I am planning on putting into a larger shell script. I have been butchering it to try and make work amongst google searches and reading awk documentation. amixer sset Master toggle | awk '{ if ( /^ Front Left/ { print $7 } == // ) print "MUTED" }'I...

6. Shell Programming and Scripting

[awk]compare a number in a string with a list

Hi, I have a program written in awk and I want to extend it to do another task. My program is a list of CVS log reports of a repository. For each file, I have some fields. One of the fields is the comment field. I want to know how I can check if a comment (which is a free text field)...

7. Shell Programming and Scripting

Need Awk command to get part of string based on delimeter

HI, Need awk command to get date and time alone from Input : "15:29:15 28.08.2010|SCHEDULE: Started program POSG1" Output expected : "15:29:15 28.08.2010" Please help.

8. Shell Programming and Scripting

How to get part of string in awk from match

Hi, Im an awk noob and I am having trouble trying to get matches. Here is my script: #!/bin/gawk -f BEGIN {} $0 ~ /<a href=".*">.*<\/a>/{print} Ideally I want to be able to get the actual link and print it. In PHP you can do preg_replace and get the match you want by using \\1 where 1...

9. Shell Programming and Scripting

Extract Part of string from 3rd field $3 using AWK

I'm executing "wc -lc" command in a c shell script to get record count and byte counts and writing them to a file. I get the result with the full pathname of the file. But I do not want the path name to be printed in the output file. I heard that using Awk we can get this but I don't have any...

Login or Register to Ask a Question