Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to search and replace string from nth column from a file?
Top Forums Shell Programming and Scripting How to search and replace string from nth column from a file? Post 302960053 by Amit Joshi on Tuesday 10th of November 2015 06:29:02 AM
Old 11-10-2015
Thanks RudiC, your solution worked for me and I have learnt 2 new function sub & gsub but I simplified it as per below command

Code:
echo '"Amit","Amit"' | awk  -v COL=2 -v SRCH="Amit" -v REP="XXX" 'BEGIN{OFS=FS="," } {sub (SRCH, REP, $COL);print }'

Code:
echo 'Amit,Amit'     | awk  -v COL=2 -v SRCH="Amit" -v REP="XXX" 'BEGIN{OFS=FS="," } {sub (SRCH, REP, $COL);print }'

It is also working fine. Can you please suggest, Is there any limitation or drawback from my commands or it will work perfectly ?
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Search and replace string only in a particular column in a delimited file

I have file with multiple columns. Column values for a record may be same. Now i have to replace a column value(this can be same for the other columns) with new value. File.txt A,B,C,D,A,B,C,D,A,B,C,D A,B,C,D,A,B,C,D,A,B,C,D A,B,C,D,A,B,C,D,A,B,C,D A,B,C,D,A,B,C,D,A,B,C,D... (1 Reply)
Discussion started by: ksailesh
1 Replies

2. 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

3. Shell Programming and Scripting

Replace the nth column date as MM/DD/YYYY

Hi, I need some unix command to replace the following thing. cat test.dat 1234|test|8/19/2009|8/20/2009|test 1234|test|8/9/2009|8/21/2009|test 1234|test|8/1/2009|8/2/2009|test after processing 1234|test|08/19/2009|08/20/2009|test 1234|test|08/09/2009|08/21/2009|test... (6 Replies)
Discussion started by: anshaa
6 Replies

4. Shell Programming and Scripting

awk to search for specific line and replace nth column

I need to be able to search for a string in the first column and if that string exists than replace the nth column with "-9.99". AW12000012012 2.38 1.51 3.01 1.66 0.90 0.91 1.22 0.82 0.57 1.67 2.31 3.63 0.00 AW12000012013 1.52 0.90 1.20 1.34 1.21 0.67 ... (14 Replies)
Discussion started by: ncwxpanther
14 Replies

5. Shell Programming and Scripting

How to search and replace string in column in file with command sed?

how to search and replace string in column in file with command sed or other search "INC0000003.in" and replace column 4 = "W" $ cat file.txt INC0000001.in|20150120|Y|N|N INC0000002.in|20150120|Y|N|N INC0000003.in|20150120|Y|N|N INC0000004.in|20150120|Y|N|Noutput... (4 Replies)
Discussion started by: ppmanja3
4 Replies

6. 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

7. Shell Programming and Scripting

awk search and replace nth column by using a variable.

I am passing a variable and replace nth value with the variable. I tried using many options in awk command but unable to ignore the special characters in the output and also unable to pass the actual value. Input : "1","2","3" Output : "1","1000","3" TempVal=`echo 1000` Cat... (2 Replies)
Discussion started by: onesuri
2 Replies

8. Shell Programming and Scripting

Search term in nth field and replace kth column

Hi, I have a text file which looks like this a.txt A,12,Apple,Red B,33,Banana,Yellow C,66,Sky,Blue I need to search for a particular field(s) in particular column(s) and for that matching line need to replace the nth column. Sample scenario 1: Search for 66 in second field and Sky in... (5 Replies)
Discussion started by: wahi80
5 Replies

9. Shell Programming and Scripting

Replace Value of nth Column of Each Line Using Array

Hello All, I am writing a shell script with following requirement: 1. I have one input file as below CHE01,A,MSC,INO CHE02,B,NST,INC CHE03,C,STM,INP 2. In shell script I have predefined array as below: Array1={A, B, C} Array2= {U09, C04, A054} (6 Replies)
Discussion started by: angshuman
6 Replies

10. 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

LEARN ABOUT DEBIAN

image_to_j2k

IMAGE_TO_J2K(1) 						  OPENJPEG TOOLS						   IMAGE_TO_J2K(1)

NAME

       image_to_j2k - convert a PNM, PGM, PPM, PGX or BMP into a J2K or JP2 file

SYNOPSIS

DESCRIPTION

       image_to_j2k converts an image into a JPEG 2000-encoded image

OPTIONS

       -ImgDir sourcedir
	   Directory of PGM, PPM, PNM, PGX or BMP files to convert

       -OutFor extension
	   J2K or JP2 output file format

       -i source
	   PNM, PGM or PPM file to convert

       -o destination
	   J2K or JP2 file to output to

       -h  Display help information

       -cinema2k fps
	   Digital Cinema 2K profile compliant codestream for 2K resolution. 24 or 48 fps.

       -cinema4k [fps]
	   Digital Cinema 4K profile compliant codestream for 4K resolution. fps default is 24

       -r ratios
	   compression factor for successive layers, comma seperated

       -q psnr
	   psnr for successive layers, comma seperated

       -n rescount
	   number of resolutions

       -b blocksize
	   width and height of code block, comma-seperated

       -c precintsize
	   width and height of precinct, comma-seperated

       -t tilesize
	   width and height of tile, comma-seperated

       -p progression
	   progression order, one of LRCP, RLCP, RPCL, PCRL, CPRL

       -s subsampling
	   subsampling factor in X and Y, comma-seperated. Values larger than 2 can produce errors

       -POC orders
	   progression order change

       -SOP
	   write SOP marker before each packet

       -EPH
	   write EPH marker after each header packet

       -M modeflags
	   Sum of the values of the modes, as follows:

	   1. BYPASS (LAZY)
	   2. RESET
	   4. RESTART (TERMALL)
	   8. VSC
	   16. ERTERM (SEGTERM)
	   32. SEGMARK (SEGSYM)
       -x indexfile
	   create an index file

       -ROI:quantize
	   quantization indices upshifted for component c between 0 and 2 inclusive with an upshift of U between 0 and 37 inclusive

       -d imageoffset
	   X and Y offset of the origin of the image, comma-seperated

       -T tileoffset
	   X and Y offset of the origin of the tiles, comma-seperated

       -I  use the irreversible DWT 9-7

EXAMPLE

       ratios: 20,10,1	Quality 1: compress 20x; Quality 2: compress 10x; Quality 3: lossless compression

       psnr: 30,40,50

       quantize: c=0,U=25

       orders: T1=0,0,1,5,3,CPRL  Title 1: Resolution 0 start, component 0 start, layer 1 end, resolution 5 end, component 3 end, CPRL progression

AUTHOR

       Written by Paul Hampson <Paul.Hampson@Pobox.com> based on the output of image_to_j2k -h as part of the Debian packaging of OpenJPEG

COPYRIGHT

       Copyright 2007 Paul Hampson

SEE ALSO

       j2k_to_image(1), <http://www.openjpeg.org/index.php?menu=doc#encoder>

1.3+dfsg							    2014-04-22							   IMAGE_TO_J2K(1)
All times are GMT -4. The time now is 10:16 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy