Sponsored Content
Top Forums Shell Programming and Scripting Unable to match string within awk printf Post 302831597 by krsnadasa on Thursday 11th of July 2013 09:10:56 AM
Old 07-11-2013
Unable to match string within awk printf

Hi All

I am working to process txt file into csv commo separated.
Code:
Input.txt
1,2,asdf,34sdsd,120,haahha2
2,2,wewedf,45sdsd,130,haahha
.....
....
 
Errorcode.txt
120
130
140
 
myawk.awk code:
 
{
BEGIN{
HEADER="f1,f2,f3,f4,f5,f6"
print HEADER}
printf '%s,%s,%s,%s,%s,%s\n",substring(..),....
}
awk -f myawk.awk Input.txt

This is fine.
Now I need to add one more header in csv as status. If field5 matches the error code in Errorcode.txt then I say "Failed" else passed.
I need to do this in printf only as I want code should be sort. I tried using match function but did not work( I basically want to perform evaluation true of false in printf by matching feld value from other file.

Can some one help me to do this?

Thanks
Krsna
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

how can awk match multi pattern in a string

Hi all, I need to category the processes in my system with awk. And for now, there are several command with similar name, so i have to match more than one pattern to pick it out. for instance: binrundb the string1, 2 & 3 may contain word, number, blank or "/". The "bin" should be ahead "rundb"... (5 Replies)
Discussion started by: sleepy_11
5 Replies

2. Shell Programming and Scripting

awk printf formatting using string format specifier.

Hi all, My simple AWK code does C = A - B If C can be a negative number, how awk printf formating handles it using string format specifier. Thanks in advance Kanu :confused: (9 Replies)
Discussion started by: kanu_pathak
9 Replies

3. Shell Programming and Scripting

How can I match lines with just one occurance of a string in awk?

Hi, I'm trying to match records using awk which contain only one occurance of my string, I know how to match one or more (+) but matching only one is eluding me without developing some convoluted bit of code. I was hoping there would be some simple pattern matching thing similar to '+' but... (9 Replies)
Discussion started by: jonathanm
9 Replies

4. Shell Programming and Scripting

Explanation for printf string in awk

hi all can any one help me to understand this bdf -t vfxs | awk '/\//{printf("%-30s%-10s%-10s%-10s%-5s%-10s\n",$1,$2,$3,$4,$5,$6)}' i want to understand the numbers %-30S% (4 Replies)
Discussion started by: maxim42
4 Replies

5. Shell Programming and Scripting

String formatting using awk printf

Hi Friends, I am trying to insert lines of the below format in a file: # x3a4914 Joe 2010/04/07 # seh Lane 2010/04/07 # IN01379 Larry 2010/04/07 I am formatting the strings as follows using awk printf: awk 'printf "# %s %9s %18s\n", $2,$3,$4}' ... (2 Replies)
Discussion started by: sugan
2 Replies

6. 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... (2 Replies)
Discussion started by: adsyuk
2 Replies

7. Shell Programming and Scripting

match string exactly with awk/sed

Hi all, I have a list that I would like to parse with awk/sed. The list is contains entries such as: JournalTitle: Biochemistry JournalTitle: Biochemistry and cell biology = Biochimie et biologie cellulaire JournalTitle: Biochemistry and experimental biology JournalTitle: Biochemistry and... (6 Replies)
Discussion started by: euval
6 Replies

8. UNIX for Dummies Questions & Answers

awk for trimming a string up to the first, then second, then third... match

Hi ! With awk, I would need to trim a string from the beginning up to the first occurrence of "1", then from the beginning up to the second occurrence of "1", then from the beginning up to the third, then the fourth...., then the last occurrence of "1". input: 1aaa1bb1ccccccc dd1e1ffff... (7 Replies)
Discussion started by: beca123456
7 Replies

9. Shell Programming and Scripting

awk : match the string and string with the quotes :

Hi all, Here is the data file: - want to match only lan3 in the output . - not lan3:1 file : OPERATING_SYSTEM=HP-UX LOOPBACK_ADDRESS=127.0.0.1 INTERFACE_NAME="lan3" IP_ADDRESS="10.53.52.241" SUBNET_MASK="255.255.255.192" BROADCAST_ADDRESS="" INTERFACE_STATE=""... (2 Replies)
Discussion started by: rveri
2 Replies

10. Shell Programming and Scripting

Awk, if line after string does not match insert

I have a large file with interface records. I need to check every record that has the string "encapsulation bridge1483" and if the next line after this does not have "ip description" then I need to insert a line to add "ip description blah_blah_blah. Sample file: interface atm 1/0.190158... (3 Replies)
Discussion started by: numele
3 Replies
MAXDB_CONNECT_ERRNO(3)							 1						    MAXDB_CONNECT_ERRNO(3)

maxdb_connect_errno - Returns the error code from last connect call

SYNOPSIS
int maxdb_connect_errno (void ) DESCRIPTION
The maxdb_connect_errno(3) function will return the last error code number for last call to maxdb_connect(3). If no errors have occurred, this function will return zero. RETURN VALUES
An error code value for the last call to maxdb_connect(3), if it failed. zero means no error occurred. EXAMPLES
Example #1 maxdb_connect_errno sample <?php $link = maxdb_connect("localhost", "XXXXXXXX", "YYYYYYYYY"); if (!$link) { printf("Can't connect to localhost. Errorcode: %d ", maxdb_connect_errno()); } ?> The above example will output something similar to: PHP Warning: maxdb_connect(): -4008 POS(1) Unknown user name/password combination [08004] <...> Can't connect to localhost. Errorcode: -4008 SEE ALSO
maxdb_connect(3), maxdb_connect_error(3), maxdb_errno(3), maxdb_error(3), maxdb_sqlstate(3). PHP Documentation Group MAXDB_CONNECT_ERRNO(3)
All times are GMT -4. The time now is 09:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy