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 stands for space and
* for the Kleene star operation. And do this at multiple places in each line (all matches).
sed -i 's/(\s)*|/|/' DataStats0914.txt
But it has no effect. What am I doing wrong?