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 302960039 by Amit Joshi on Monday 9th of November 2015 11:53:40 PM
Old 11-10-2015
How to search and replace string from nth column from a file?
I wanted to search for a string and replace it with other string from nth column of a file which is comma seperated which I am able to do with below

# For Comma seperated file without quotes
Code:
 awk 'BEGIN{OFS=FS=","}$"'"$ColumnNo"'"=="'"$PPK"'"{$"'"$ColumnNo"'"="'"$NPK"'"}{print}' ${FileName}

# For Comma seperated file with quotes
Code:
awk 'BEGIN{OFS=FS=","}$"'"$ColumnNo"'"=="\""'"$PPK"'"\""{$"'"$ColumnNo"'"="\""'"$NPK"'"\""}{print}' ${FileName}

But I wanted to make it in one command so that it works for both type of file. I know I can do with sed command sed -i "s/$PPK/$NPK/" $FileName but it replaces the value in other columns as well so can anyone suggest what can be done ?

Here ColumnNo is the nth column from which I wanted to replace PPK to NPK.

Please find other details
Code:
 uname -a
Linux XXXXXXX 2.6.32-220.25.1.el6.x86_64 #1 SMP Tue Aug 14 13:14:38 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
echo $SHELL
/bin/ksh
echo $KSH_VERSION
Version JM 93t+ 2010-06-21

Last edited by Amit Joshi; 11-10-2015 at 12:59 AM.. Reason: Added more details
 

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 CENTOS

grub2-file

GRUB-FILE(1)						      General Commands Manual						      GRUB-FILE(1)

NAME

       grub-file -- Check if FILE is of specified type.

SYNOPSIS

       grub-file (--is-i386-xen-pae-domu | --is-x86_64-xen-domu |
		  --is-x86-xen-dom0 | --is-x86-multiboot |
		  --is-x86-multiboot2 | --is-arm-linux | --is-arm64-linux |
		  --is-ia64-linux | --is-mips-linux | --is-mipsel-linux |
		  --is-sparc64-linux | --is-powerpc-linux | --is-x86-linux |
		  --is-x86-linux32 | --is-x86-kfreebsd | --is-i386-kfreebsd |
		  --is-x86_64-kfreebsd | --is-x86-knetbsd |
		  --is-i386-knetbsd | --is-x86_64-knetbsd | --is-i386-efi |
		  --is-x86_64-efi | --is-ia64-efi | --is-arm64-efi |
		  --is-arm-efi | --is-hibernated-hiberfil | --is-x86_64-xnu |
		  --is-i386-xnu | --is-xnu-hibr | --is-x86-bios-bootsector)
		  FILE

DESCRIPTION

       grub-file is used to check if FILE is of a specified type.

OPTIONS

       --is-i386-xen-pae-domu
	      Check if FILE can be booted as i386 PAE Xen unprivileged guest kernel

       --is-x86_64-xen-domu
	      Check if FILE can be booted as x86_64 Xen unprivileged guest kernel

       --is-x86-xen-dom0
	      Check if FILE can be used as Xen x86 privileged guest kernel

       --is-x86-multiboot
	      Check if FILE can be used as x86 multiboot kernel

       --is-x86-multiboot2
	      Check if FILE can be used as x86 multiboot2 kernel

       --is-arm-linux
	      Check if FILE is ARM Linux

       --is-arm64-linux
	      Check if FILE is ARM64 Linux

       --is-ia64-linux
	      Check if FILE is IA64 Linux

       --is-mips-linux
	      Check if FILE is MIPS Linux

       --is-mipsel-linux
	      Check if FILE is MIPSEL Linux

       --is-sparc64-linux
	      Check if FILE is SPARC64 Linux

       --is-powerpc-linux
	      Check if FILE is POWERPC Linux

       --is-x86-linux
	      Check if FILE is x86 Linux

       --is-x86-linux32
	      Check if FILE is x86 Linux supporting 32-bit protocol

       --is-x86-kfreebsd
	      Check if FILE is x86 kFreeBSD

       --is-i386-kfreebsd
	      Check if FILE is i386 kFreeBSD

       --is-x86_64-kfreebsd
	      Check if FILE is x86_64 kFreeBSD

       --is-x86-knetbsd
	      Check if FILE is x86 kNetBSD

       --is-i386-knetbsd
	      Check if FILE is i386 kNetBSD

       --is-x86_64-knetbsd
	      Check if FILE is x86_64 kNetBSD

       --is-i386-efi
	      Check if FILE is i386 EFI file

       --is-x86_64-efi
	      Check if FILE is x86_64 EFI file

       --is-ia64-efi
	      Check if FILE is IA64 EFI file

       --is-arm64-efi
	      Check if FILE is ARM64 EFI file

       --is-arm-efi
	      Check if FILE is ARM EFI file

       --is-hibernated-hiberfil
	      Check if FILE is hiberfil.sys in hibernated state

       --is-x86_64-xnu
	      Check if FILE is x86_64 XNU (Mac OS X kernel)

       --is-i386-xnu
	      Check if FILE is i386 XNU (Mac OS X kernel)

       --is-xnu-hibr
	      Check if FILE is XNU (Mac OS X kernel) hibernated image

       --is-x86-bios-bootsector
	      Check if FILE is BIOS bootsector

SEE ALSO

       info grub

								  Web Feb 26 2014						      GRUB-FILE(1)
All times are GMT -4. The time now is 09:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy