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.