Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Shell script for search and replace by field Post 302720369 by chandrath on Tuesday 23rd of October 2012 11:45:58 PM
Old 10-24-2012
Don,

Thank you very much for your valuable inputs and comments!. Appreciate all your help!
I had slight variation in the rules file when there is a rule for a field that do not exist in input, as well the 'Contains' requirement as below:

Rules file:

Code:
field|search|condition|replace|
field1|XX|Equals|rc
field1|$|Contains|  
field2|#|Contains|
field2|!|Contains|c
field2|yy|Equals|rc
fieldx|{{|Equals|

Input file:
Code:
field1|field2|field3|
rc11|rc12|xxx|
rc$$$21|rc#21|yyy|
XX|yy|fff|
rc41|r!42||

I am getting error due to the extra Rule
Code:
fieldx|{{|Equals|

, for which fieldx does not exist in Inpurt file.
Error message: "awk: Field is not correct. The input line number is 2. "
Appreciate your help to handle this.

After I deleted the "fieldx|{{|Equals|" record from Rules file, I am getting below output:
Code:
field1|field2|field3|
rc11|rc12|xxx|
rc$$21|rc21|yyy|
rc|rc|fff|
rc41|rc42||

But, the expected output I need is :
Code:
rc11|rc12|xxx|
rc21|rc21|yyy|     ---> the field1 has '$$$' each '$' sign in this field to be replaced with ''.
rc|rc|fff|
rc41|rc42||

The Rule for "fieldx" can be reported into Reject file saying it did not exist in input.
Any help is highly appreciated in dealing with these 2 scenarios.

Thank you!
Chand.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

search and replace dynamic data in a shell script

Hi, I have a file that looks something like this: ... 0,6,256,87,0,0,0,1187443420 0,6,438,37,0,0,0,1187443380 0,2,0,0,0,10,0,1197140320 0,3,0,0,0,10,0,1197140875 0,2,0,0,0,23,0,1197140332 0,3,0,0,0,23,0,1197140437 0,2,0,0,0,17,0,1197140447 0,3,0,0,0,17,0,1197140543... (8 Replies)
Discussion started by: csejl
8 Replies

2. Shell Programming and Scripting

awk search and replace field

I am writing a c++ program that has many calls of pow(input,2). I now realize that this is slowing down the program and these all should be input * input for greater speed. There should be a simple way of doing this replacement throughout my file with awk, but I am not very familiar with awk.... (2 Replies)
Discussion started by: bluejayek
2 Replies

3. Shell Programming and Scripting

Perl - search and replace a particular field

Hi, I have a file having around 30 records. Each record has 5 fields delimited by PIPE. Few records in the file having Junk characters in the field2 and field4. I found the junk charcter and I tested it and replace the junk with space with the command below perl -i -p -e "s/\x00/ /g"... (1 Reply)
Discussion started by: ramkrix
1 Replies

4. Shell Programming and Scripting

Search duplicate field and replace one of them with new value

Dear All, I have file with 4 columns: 1 AA 0 21 2 BB 0 31 3 AA 0 21 4 CC 0 41 I would like to find the duplicate record based on column 2 and replace the 4th column of the duplicate by a new value. So, the output will be: 1 AA 0 21 2 BB 0 31 3 AA 0 -21 4 CC 0 41 Any suggestions... (3 Replies)
Discussion started by: ezhil01
3 Replies

5. Shell Programming and Scripting

Search a string,get line and replace with second field

Hi, I need to search for source path in file2 , as per file1 and if found get the next line and take the field value and put it in URL value of file1. In file1, NF is not same for all the lines. file1: <type source="/home/USER/Desktop" Dest="/home/USER/DIR1/Desktop" URL="ssh/path"/> <type... (8 Replies)
Discussion started by: greet_sed
8 Replies

6. Shell Programming and Scripting

Search and replace field?

I have 2 files A.txt and B.txt A.txt 3 fields and separate by a comma some,thing,florida any1,thing1,california some2,thing2,dallas just,fun,kansas B.txt has 8 fields and separate by a comma what,ever,florida-state,,,,,, some,one,dallas_state,,,,,, You will see 3rd fields are the... (5 Replies)
Discussion started by: sabercats
5 Replies

7. Shell Programming and Scripting

awk search and replace in a targeted field instead of $0

Hi I would like to apply this gawk command: gawk '{$0=gensub(/\y+\y/,"","g"); print}' file not to the whole $0 but just to the part of $0 that is between: (a number)"> and </mrk> Is it possible? thanks for your help. (4 Replies)
Discussion started by: louisJ
4 Replies

8. Shell Programming and Scripting

Search field in text file and replace value

Hi there, First of all this is my first post here. Thank you in advance for your help. What I am trying to do is the following. I have a text file where each field of each row is separated by a tabulator. Looks like this: ATOM 1 N HSE A 26 3.033 -10.429 -2.262 1.00 17.07 ... (8 Replies)
Discussion started by: doom4
8 Replies

9. Shell Programming and Scripting

Search for a value and replace other field in the same set

Hello friends, I have huge file with many sets where each "set" has few lines and each set always begins with "Set" in Sq brackets as shown above. # cat file1 (2 Replies)
Discussion started by: magnus29
2 Replies

10. UNIX for Dummies Questions & Answers

Search and replace the last field

Hi All, Seeking for your assistance on how to search and replace the last field/column. please see sample below: inputfile1.csv ="8923523434",="543623534"="afd23535623",="100"="200" ="8923523431",="543623536"="afd23535626",="101"="201"... (3 Replies)
Discussion started by: poginiks
3 Replies
AUSEARCH_ADD_expression(3)					  Linux Audit API					AUSEARCH_ADD_expression(3)

NAME
ausearch_add_expression - build up search expression SYNOPSIS
#include <auparse.h> int ausearch_add_expression(auparse_state_t *au, const char *expression, char **error, ausearch_rule_t how); DESCRIPTION
ausearch_add_item adds an expression to the current audit search expression. The search conditions can then be used to scan logs, files, or buffers for something of interest. The expression parameter contains an expression, as specified in ausearch-expression(5). The how parameter determines how this search expression will affect the existing search expression, if one is already defined. The possi- ble values are: AUSEARCH_RULE_CLEAR Clear the current search expression, if any, and use only this search expression. AUSEARCH_RULE_OR If a search expression E is already configured, replace it by (E || this_search_expression). AUSEARCH_RULE_AND If a search expression E is already configured, replace it by (E && this_search_expression). RETURN VALUE
If successful, ausearch_add_expression returns 0. Otherwise, it returns -1, sets errno and it may set *error to an error message; the caller must free the error message using free(3). If an error message is not available or can not be allocated, *error is set to NULL. SEE ALSO
ausearch_add_item(3), ausearch_add_interpreted_item(3), ausearch_add_timestamp_item(3), ausearch_add_regex(3), ausearch_set_stop(3), ause- arch_clear(3), ausearch_next_event(3), ausearch-expression(5). AUTHOR
Miloslav Trmac Red Hat Feb 2008 AUSEARCH_ADD_expression(3)
All times are GMT -4. The time now is 09:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy