Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Search for a string and replace the searched string in the same position in samefile

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Search for a string and replace the searched string in the same position in samefile
# 15  
Old 03-13-2009
Quote:
Originally Posted by vgersh99
Code:
nawk -v cols='1 2 3'  'BEGIN {n=split(cols, colsA, FS)} {for(i=1; i<=n; i++) sub(/^01/,"20",$colsA[i]); print}' $file1


Please explain me your command Vgresh.
Thanks!
# 16  
Old 03-13-2009
"-v cols='1 2 3' " - a list of columns to operate on
Code:
# split cols in an array colsA
BEGIN {n=split(cols, colsA, FS)}

# iterate through array colsA calling "subs" on every entry of colsA 
{for(i=1; i<=n; i++) sub(/^01/,"20",$colsA[i]); print}

# 17  
Old 03-13-2009
Quote:
Originally Posted by vgersh99
"-v cols='1 2 3' " - a list of columns to operate on
Code:
# split cols in an array colsA
BEGIN {n=split(cols, colsA, FS)}

# iterate through array colsA calling "subs" on every entry of colsA 
{for(i=1; i<=n; i++) sub(/^01/,"20",$colsA[i]); print}

what is the value of colsA, FS and how??
and i tried your command but the 3rd column is not changing while the other two columns changed.Pls help
# 18  
Old 03-13-2009
Quote:
Originally Posted by ganesh_248
what is the value of colsA, FS and how??
colsA is an array with values passed via cols from CLI.
FS - assumed to be a default FS as it's not changed anywhere in the code.
how - not sure what 'how' is - it's not used anywhere in the code.

Quote:
Originally Posted by ganesh_248
and i tried your command but the 3rd column is not changing while the other two columns changed.Pls help
Strange it worked just fine on my sample file:
Code:
01asldfj 01zx,cnmbv 01890

# 19  
Old 03-13-2009
Quote:
Originally Posted by vgersh99
colsA is an array with values passed via cols from CLI.
FS - assumed to be a default FS as it's not changed anywhere in the code.
how - not sure what 'how' is - it's not used anywhere in the code.


Strange it worked just fine on my sample file:
Code:
01asldfj 01zx,cnmbv 01890

This is my sample text

Processed Date Start Date End Date
0109/2/1 07:18:06 0109/1/31 04:00:00 0109/2/1 04:00:00

and when i used your command i got the output as
Processed Date Start Date End Date
2009/2/1 07:18:06 2009/1/31 04:00:00 0109/2/1 04:00:00

My file is a "tab"delimited file.
# 20  
Old 03-13-2009
Quote:
Originally Posted by vgersh99
colsA is an array with values passed via cols from CLI.
FS - assumed to be a default FS as it's not changed anywhere in the code.
how - not sure what 'how' is - it's not used anywhere in the code.


Strange it worked just fine on my sample file:
Code:
01asldfj 01zx,cnmbv 01890

sorry ,i still don get what is CLI in
"colsA is an array with values passed via cols from CLI."
# 21  
Old 03-13-2009
Quote:
Originally Posted by ganesh_248
This is my sample text

Processed Date Start Date End Date
0109/2/1 07:18:06 0109/1/31 04:00:00 0109/2/1 04:00:00

and when i used your command i got the output as
Processed Date Start Date End Date
2009/2/1 07:18:06 2009/1/31 04:00:00 0109/2/1 04:00:00

My file is a "tab"delimited file.
you have SIX fields in your file.
Code:
nawk -v OFS='\t' -v cols='1 3 5'  'BEGIN {n=split(cols, colsA, FS)} {for(i=1; i<=n; i++) sub(/^01/,"20",$colsA[i]); print}' $file1

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Search partial string in a file and replace the string - UNIX

I have the below string which i need to compare with a file and replace this string in the file which matches closely. Can anyone help me on this. string(Scenario 1)- user::r--,user::ourfrd:r-- String(Scenario 2)- user::r-- File **** # file: /local/Desktop/myfile # owner: me # group:... (6 Replies)
Discussion started by: sarathy_a35
6 Replies

2. UNIX for Dummies Questions & Answers

Search for a string,delete the line and replace with new string in a file

Hi Everyone, I have a requirement in ksh where i have a set of files in a directory. I need to search each and every file if a particular string is present in the file, delete that line and replace that line with another string expression in the same file. I am very new to unix. Kindly help... (10 Replies)
Discussion started by: Pradhikshan
10 Replies

3. Shell Programming and Scripting

Search for a string at a particular position and replace with blank based on position

Hi, I have a file with multiple lines(fixed width dat file). I want to search for '02' in the positions 45-46 and if available, in that lines, I need to replace value in position 359 with blank. As I am new to unix, I am not able to figure out how to do this. Can you please help me to achieve... (9 Replies)
Discussion started by: Pradhikshan
9 Replies

4. Shell Programming and Scripting

Search String and extract few lines under the searched string

Need Assistance in shell programming... I have a huge file which has multiple stations and i wanted to search particular station and extract few lines from it and the rest is not needed Bold letters are the stations . The whole file has multiple stations . Below example i wanted to search... (4 Replies)
Discussion started by: ajayram_arya
4 Replies

5. Shell Programming and Scripting

Search a string in a text file and add another string at the particular position of a line

I am having a text file which is having more than 200 lines. EX: 001010122 12000 BIB 12000 11200 1200003 001010122 2000 AND 12000 11200 1200003 001010122 12000 KVB 12000 11200 1200003 In the above file i want to search for string KVB and add/replace... (1 Reply)
Discussion started by: suryanarayana
1 Replies

6. Shell Programming and Scripting

sed or awk command to replace a string pattern with another string based on position of this string

here is what i want to achieve... consider a file contains below contents. the file size is large about 60mb cat dump.sql INSERT INTO `table1` (`id`, `action`, `date`, `descrip`, `lastModified`) VALUES (1,'Change','2011-05-05 00:00:00','Account Updated','2012-02-10... (10 Replies)
Discussion started by: vivek d r
10 Replies

7. UNIX for Dummies Questions & Answers

Search a string in the file and then replace another string after that position

Hi I am looking for a particular string in a file.If the string exists, then I want to replace another string with some other text.Once replaced, search for the same text after that character position in the file. :wall: E.g: Actual File content: Hello Name: Nitin Raj Welcome to Unix... (4 Replies)
Discussion started by: dashing201
4 Replies

8. Shell Programming and Scripting

Search, replace string in file1 with string from (lookup table) file2?

Hello: I have another question. Please consider the following two sample, tab-delimited files: File_1: Abf1 YKL112w Abf1 YAL054c Abf1 YGL234w Ace2 YKL150w Ace2 YNL328c Cup9 YDR441c Cup9 YDR442w Cup9 YEL040w ... File 2: ... ABF1 YKL112W ACE2 YLR131C (9 Replies)
Discussion started by: gstuart
9 Replies

9. Shell Programming and Scripting

Search for a string and replace the searched string in the same position

Hi All, My requisite is to search for the string "0108"(which is the year and has come in the wrong year format) in a particular column say 4th column in a tab delimited file and then replace it with 2008(the correct year format) in the same position where 0108 was found..The issue is the last... (15 Replies)
Discussion started by: ganesh_248
15 Replies

10. Shell Programming and Scripting

Find the position of a string and replace with another string

Hi, I have a file named "Test_2008_01_21" The file contains a string "manual" that occurs many times in the file How can i find the positions of the string "manual" in the file Ex: if the string " manual " occurs three times in the file. i want to replace the second occurance of string... (6 Replies)
Discussion started by: bab123
6 Replies
Login or Register to Ask a Question