Condition check using awk

Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Condition check using awk
# 1  
Old 01-10-2013
Condition check using awk

I have a file in the following format

"SYLVESTER,WILLARD G"|"S00633600"|"221052958A"|"H2256"|"015"|""|"00000042BASJ"|"665303"|"N"|"20100211"|"380.4"|""|""|""|"5400"|"20110218"|""|"20110218"|"FEESC"|"D"|"F"|"P"
"PURINGTON-KELLEY,C"|"S00808783"|"029424717A"|"H2256"|"024"|"MEMBER JOINED ANOTHER MEDICARE RISK PLAN"|"00000049BAQS"|"SS2323"|"Y"|"20100218"|"728.87"|"782.0"|""|""|"6040"|"20110218"|""|"20110218"|"FEESC"|"D"|"F"|"P"

I need to check if first two characters of the 8th column start with SS. If they start with SS , replace the 8th column by "MEMBER" else replace the 8th column by "PROVIDER"

Desired output :
"SYLVESTER,WILLARD G"|"S00633600"|"221052958A"|"H2256"|"015"|""|"00000042BASJ"|"PROVIDER"|"N"|"20100211"|"380.4"|""|""|""|"5400"|"20110218"|""|"20110218"|"FEESC"|"D"|"F"|"P"
"PURINGTON-KELLEY,C"|"S00808783"|"029424717A"|"H2256"|"024"|"MEMBER JOINED ANOTHER MEDICARE RISK PLAN"|"00000049BAQS"|"MEMBER"|"Y"|"20100218"|"728.87"|"782.0"|""|""|"6040"|"20110218"|""|"20110218"|"FEESC"|"D"|"F"|"P"

This is something I tried using awk but not sure how to specify the column name


awk -v srch="$search" -v repl="$replace" '{ sub(srch,repl,$0); print $0 }' newfile

Can someone please help
# 2  
Old 01-10-2013
awk -v qq='"' '{$8= (qq ($8~("^"qq"SS")?"MEMBER":"PROVIDER"))}1' FS='|' OFS='|' myFile

This User Gave Thanks to vgersh99 For This Post:
# 3  
Old 01-10-2013
Here you go:
$ provider=PROVIDER
$ awk -v srch="$search" -v repl="$replace" -vprov=$provider\
    'BEGIN {FS="\"\|\"";OFS="\"|\""}
    '  file
"SYLVESTER,WILLARD G"|"S00633600"|"221052958A"|"H2256"|"015"|""|"00000042BASJ"|"PROVIDER"|"N" . . .
"PURINGTON-KELLEY,C"|"S00808783"|"029424717A"|"H2256"|"024"|"MEMBER JOINED ANOTHER MEDICARE RISK PLAN"|"00000049BAQS"|"MEMBER"|"Y". . .

P.S.: small addition to vgersh99's proposal: "))}1 --- ") qq)}1>
# 4  
Old 01-10-2013
Here is another way to do it using "|" as the field separator instead of just |:
awk -F '"\\|"' 'BEGIN{OFS = "\"|\""}
{$8 = ($8 ~ /^SS/) ? "MEMBER" : "PROVIDER"}
1' myFile

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Check two condition in while loop

Hi, I Have to check two condition in while loop every 2 minutes. while loop is accompanied with number of times it will check.Please help in putting the two condition in while loop as appropriate. z= input value, A=1 while do 1.check the file output,if the file output is N then keep on... (2 Replies)
Discussion started by: netdbaind
2 Replies

2. Shell Programming and Scripting

Need to check a condition using SFTP command

HI, I connected to a remote FTP server using sftp command. Need to check if any files are present inside a folder in server directory and then remove if present. The code should look like this How can this condition be written. Thanks in advance, (2 Replies)
Discussion started by: confused_info
2 Replies

3. Shell Programming and Scripting

Check the value in xml based on condition

Hi, I have a log file having n number of xml's like the one below. <uOStatus xmlns:env=""... (3 Replies)
Discussion started by: Neethu
3 Replies

4. Shell Programming and Scripting

if condition to check the hostname (unix)

I want to know the if condition in checking the hostname in unix and then running a cron job (all in a single line) Thanks (2 Replies)
Discussion started by: prash358
2 Replies

5. Shell Programming and Scripting

sed to check two condition need solution

Hi, I am having a file in below format server-1 Win2008:server-1-1700,1774,290104720,290104987:server-1 server-2 AIX:server-2-:server-2 server-2 I want the output like this Win2008:server-1-1700,1774,290104720,290104987:standalon-server AIX:server-2-:VIO-Sever I used the... (7 Replies)
Discussion started by: ranjancom2000
7 Replies

6. Shell Programming and Scripting

HELP with AWK one-liner. Need to employ an If condition inside AWK to check for array variable ?

Hello experts, I'm stuck with this script for three days now. Here's what i need. I need to split a large delimited (,) file into 2 files based on the value present in the last field. Samp: Something.csv bca,adc,asdf,123,12C bca,adc,asdf,123,13C def,adc,asdf,123,12A I need this split... (6 Replies)
Discussion started by: shell_boy23
6 Replies

7. Shell Programming and Scripting

Check condition inside the loop

Hi, I am in trouble. I can get inside my condition test inside a loop : I am in ksh (solaris) while read file do <commande to retrieve file> >> ${LOG_RETRIEVE_FILE.log} msg_err=$(cat ${LOG_RETRIEVE_FILE.log} | grep "error retrieve") if ; then <sendmail> exit 1 fi done I tried... (6 Replies)
Discussion started by: Aswex
6 Replies

8. Shell Programming and Scripting


Hello I want to compare values of two variables as CHECK condition in a while loop. eg: var1=0 var2=10 while do echo " $var1 " var1=`expr $var1 + 1` done However this is giving error.How to do it in a proper manner? Thanks. (3 Replies)
Discussion started by: dashing201
3 Replies

9. Shell Programming and Scripting

Help with shell script to check the condition.

:) Hi, I want to script for this scenerio, OSR Settings Scenario : We are looking to find all the *.a files from the following locations in the filesystem of a server. OSR Directories /etc /bin /usr/bin /usr/sbin /var/adm These *.a files should have the permissions on... (12 Replies)
Discussion started by: sakthilinux
12 Replies
Login or Register to Ask a Question

Featured Tech Videos