How to replace last occurence of a character?

Question

I have a file composed by lines like these ones:

199240050;0180209199240050;0
199240241;0180209199240241;0
199240207;0180209199240207;0
199240400;0180209199240400;0

I should replace last number with "Active" if it is "0", Or "Inactive" if it is "1".

I've tried with sed but the occurrence of ";0" in the middle of the line gets changed too.

It should be used in a linux bash script.

---

I tried the solution given by DopeGhoti but it fails:

$ sed 's/0$/active/;s/1$/inactive/'  myLines.txt
800600346                078136521                       active

While the format of the input file should not change.

The second solution appends ";active" at the end, without replacing:

$ awk -F\; 'BEGIN {OFS=";"} { if( $3 == 1 ) { print $1,$2,"inactive" } else { print $1,$2,"active" } }'  myLines.txt
800010654                0295445503                     0;;active

And George Vasiliou's also fails:

$ awk '$NF?$NF="active":$NF="inactive"' FS=';' OFS=';' myLines.txt
active
active
active
active

Answer 1

For your given data in a file called input:

$ awk -F\; 'BEGIN {OFS=";"} { if( $3 == 1 ) { print $1,$2,"inactive" } else { print $1,$2,"active" } }' input
199240050;0180209199240050;active
199240241;0180209199240241;active
199240207;0180209199240207;active
199240400;0180209199240400;active

Alternatively, with sed:

$ sed 's/\;0$/active/;s/\;1$/inactive/' input
199240050;0180209199240050;active
199240241;0180209199240241;active
199240207;0180209199240207;active
199240400;0180209199240400;active

Answer 2

One more awk, more idiomatic :

$ awk '$NF?$NF="inactive":$NF="active"' FS=';' OFS=';' file

Last field $NF is evaluated . If found zero then Last Field $NF is changed to "active" , otherwise is changed to "inactive".

Print is omitted since will be performed by default.

Alternative , even more idiomatic by using ternary operation in variable assignment :

$ awk '$NF=($NF?"inactive":"active")' FS=';' OFS=';' file

Answer 3

With perl:

perl -pe 's/\d+(?!.*\d)/$& ? "Inactive" : "Active"/e' < file

Replaces the first sequence of digits that is not followed by any digit with "Inactive" if it's 0 or "Active" otherwise.