Alternatively, if you have perl:

$
$ perl -ne 'substr($_,-2,1)="Z"; print' result.dat
1.11a,Test result for scenario 1,1 2 3 4,Z
1.12b,Test result for scenario 2,incomplete,Z
1.13,Test result for scenario 3, 4 5 6,Z
$

Hello,

Per our forum rules, all users must write in English, use semi-formal or formal English language and style, and correct spelling errors.

The reason for this is that most software and operating systems are written in English and these are software related technical forums.

In addition, nearly 95% of all visitors to this site come here because they are referred by a search engine. In order for future searches on your post (with answers) to work well, you need to spell correctly!

So, as a benefit and courtesy to current and future knowledge seekers, please be careful with your language, check your spelling and correct your spelling errors. You might receive a forum infraction if you don't pay attention to this.

Also, do not write in cyberpunk or abbreviated chat style under any circumstances and do not use profanity. This is not a chat room, it is a formal knowledge base to serve you and everyone, of all ages and cultural backgrounds.

Thanks!

The UNIX and Linux Forums

people have shown you how to use awk already. last field value stands for $NF, second field stands for $2. therefore, pls try and show some code. Read the awk docs especially.

sed 's/.$/z/'

this expression allow to replace last character by z

-----Post Update-----

try1 is your file

cat try1 | while read line; do res=$(echo $line | awk -F "," '{print $NF}');if [ $res = "p" ];then var=$(echo $line | awk -F "," '{print $2}');echo $var;fi; done

-----Post Update-----

try1 is your file

cat try1 | while read line; do res=$(echo $line | awk -F "," '{print $NF}');if [ $res = "p" ];then var=$(echo $line | awk -F "," '{print $2}');echo $var;fi; done

no need while loop, cat and those extra if/else and awk. Just one awk command can do it.

certainly, but i haven't good knowledges in command awk.
I'm a beginner.