remove white space before delimiter with sed
- by Erik
I have data of the following format that I want to input into LibreOffice calc
data | num | num | num | num
For some reason Libreoffice does not think the string "3214 " is a number by default (trailing white space).
I want to replace '(\s)*|' with '|' where \s stands for space and * for the Kleene star operation. And do this at multiple places in each line (all matches).
I tried:
sed -i 's/(\s)*|/|/' DataStats0914.txt
But it has no effect.