Replace last characters in each line

sed

I have a csv file with floats ending in a character:

1, 2, 6, 7, "p"
1, 6, 7, 2, "e"

etc.

I'd like to replace "p" with 0 and "e" with 1 for a classification task. That is, I would like:

1, 2, 6, 7, 0
1, 6, 7, 2, 1

For all 8000 lines in my file.

I have tried:

sed -i 's/"p"$/0' filename.csv

and

sed -i 's"p"$0//' filename.csv

but neither work. How can I replace several characters in each line using sed?

Best Answer

sed 's/"p"$/0/;s/"e"/1/' file.txt

Related Solutions

Can Sed Replace New Line Characters?

With GNU sed and provided POSIXLY_CORRECT is not in the environment (for single-line input):

sed -i ':a;N;$!ba;s/\n/,/g' test.txt

From https://stackoverflow.com/questions/1251999/sed-how-can-i-replace-a-newline-n :

create a label via :a
append the current and next line to the pattern space via N
if we are before the last line, branch to the created label $!ba ($! means not to do it on the last line (as there should be one final newline)).
finally the substitution replaces every newline with a comma on the pattern space (which is the whole file).

How to replace a word with new line

Use this:

sed 's/|END|/\n/g' test.txt

What you attempted doesn't work because sed uses basic regular expressions, and your sed implementation has a \| operator meaning “or” (a common extension to BRE), so what you wrote replaces (empty string or END or empty string) by a newline.

Best Answer

Related Solutions

Can Sed Replace New Line Characters?

How to replace a word with new line

Related Question