I want to import some data from a csv/text file to Calc.
In the first column I'd like to have the 'Dummy text # i', and in the second column the numerical value.
In the text file, 'Dummy text # i' and the numerical value are separated by several blank spaces. Thus, I would probably achieve this by using ' ' (two blank spaces) as delimiter, then ticking the 'merge delimiters option.
However, I don't now how to do this. I tried using 'other' as custom separator but it seems to interpret any number of blank spaces as just one.
This is the initial data that I copy and paste to the spreadsheet.
And this is what I can get. Note that unmarking the 'space' option, only accomplishes accounting for the right-trailing spaces.
As you can see, none of the following serve. The 'Dummy text # i' is spread in various columns, as Libreoffice seems to be taking one single space as separator.
The second one (merge delimiters)comes closer, but still doesn't get the 'Dummy text # i' in the first column.
As @Zina tested it in another version, I checked my Libreoffice version (184.108.40.206), but I'm sceptical about it being the root cause, as it seems a rather glaring flaw.
What am I doing wrong? Might it be a version flaw? Thanks in advance.