Replacing the last character for each line in a file

123script · #1 (**permalink**) 05-27-2009

Hello,
I have a csv file and will like to replace the last character of each line in the file with Z

ghostdog74 · #2 (**permalink**) 05-27-2009

what have you got?

cfajohnson · #3 (**permalink**) 05-27-2009

Use awk's substr and length functions.

123script · #4 (**permalink**) 05-27-2009

Example of file content:
ksh: cat result.dat
1.11a,Test result for scenario 1,1 2 3 4,p
1.12b,Test result for scenario 2,incomplete,q
1.13,Test result for scenario 3, 4 5 6,P
...

The number of characters per line varies but the last field is always one character (e.g ,p) and the number of fields per line is always 4

Thanks for assisting

vidyadhar85 · #5 (**permalink**) 05-27-2009

this will do i guess

Code:

awk -F"," '{gsub($NF,"z")}{print}' filename

devtakh · #6 (**permalink**) 05-27-2009

For easier understanding:

Code:

 awk '{printf("%s",substr($0,1,length($0)-1));b=substr($0,length($0)-1,1);sub(b,"Z",b);print b}' infile

-Devaraj Takhellambam

Jagadeeswaran.K · #7 (**permalink**) 05-28-2009

awk '{printf("%sZ\n",substr($0,1,length($0)-1)) ;}' test

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Awk not working due to missing new line character at last line of file	pinnacle	Shell Programming and Scripting	2	05-07-2009 09:51 PM
error while replacing a string by new line character in sed	millan	Shell Programming and Scripting	8	04-28-2009 05:06 AM
Replacing a character string in a file	rjsha1	Shell Programming and Scripting	13	04-11-2009 01:07 PM
Replacing a character in a line	Usha Shastri	UNIX for Dummies Questions & Answers	2	04-02-2009 02:08 AM
Replacing character in file with null value	HLee1981	Shell Programming and Scripting	18	07-18-2006 01:33 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: