Replace with sed until match in a line

sedtext processing

I have to replace all "." characters before the "=" character in every line in a file.
The lines are like this:

one.two.three=something
four.five=1
six.seven=127.0.0.1
eight.nine.ten.eleven=somethingwerylong
twelve=something.with.dots

and so on…

The result must be like this:

onetwothree=something
fourfive=1
sixseven=127.0.0.1
eightnineteneleven=somethingwerylong
twelve=something.with.dots

Best Answer

sed -e :1 -e 's/^\([^=]*\)\./\1/; t1'

t1 branches to the 1 label if there has been a successful s command. That's one of the ways to implement conditional loops in sed.

Or:

awk -F = -v OFS== '{gsub(/\./, "", $1); print}'

Related Solutions

Add leading zeros until all lines before the comma consist of nine characters and subsequently insert a character every three digits using sed

If your input don't have long sequence number in second field, try:

$ sed -e 's|^[^,]*|#000000000&|;s|#[^,]*\(.\{9\}\),|\1,|;s|\([0-9]\{3\}\)|\1/|g;s|/\([^0-9]\)|\1|;s|/$||' file
000/012/345,1s4c3v6s3nh6
123/456/789,9h5vgbdx34dc
000/000/012,7h4f45dcvbgh
001/234/567,09klijnmh563

Explanation

s|^[^,]*|#000000000&|: we match all thing from start to the first ,, replace it with a maker # and n numbers 0, where n is length we want to pad.
s|#[^,]*$.\{9\}$,|\1,|: we match all thing from the marker to the first ,, only keep the last 9 characters before ,, discard the rest.
s|$[0-9]\{3\}$|\1/|g: add a / each 3 sequence of digits.
s|/$[^0-9]$|\1|;s|/$||: if after / is not a number or / is at the end of line, we remove it.

or easier with perl:

$ perl -F',' -anle '
    $F[0] = sprintf "%09s", $F[0];
    $F[0] =~ s|.{3}|$&/|g;
    chop $F[0];
    print join ",",@F;
' file
000/012/345,1s4c3v6s3nh6
123/456/789,9h5vgbdx34dc
000/000/012,7h4f45dcvbgh
001/234/567,09klijnmh563

Replace last characters in each line

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

Best Answer

Related Solutions

Add leading zeros until all lines before the comma consist of nine characters and subsequently insert a character every three digits using sed

Replace last characters in each line

Related Question