[libreoffice-users] Import in Calc: what do I do wrong?

What do I do wrong?

 

In the process of - slowly - switching from MS/365 for Linux/LibreOffice (Debian 13.3) I encounter 
some problems with Calc

 

Please see below a part of a directory listing of an Obsidian vault - made with KFind

 

Try to import it Calc for some purposes, but the <dot> and <slash> or their combination 
<dot><slash> seems to be interpreted as column delimiters. I tried to specify no delimiters at alI: 
I want to have the full file path and name in a single column.

 

./ICT/Linux/Raspberry Pi/AdGuardHome installatie.md

./ICT/Linux/Raspberry Pi/Spencer’s Desk꞉ Using a Raspberry Pi to hide from my ISP.md

./ICT/Linux/Raspberry Pi/Updating to Pi-hole v6 and enabling HTTPS!.md

./ICT/Linux/Raspberry Pi/7 Things I Wish I Knew Before Running a Pi-hole.md

./ICT/Linux/Raspberry Pi/AdguardTeamAdGuardHome Network-wide ads & trackers blocking DNS server.md

./ICT/Projects/Debian KDE op Paradigit PC/Debian KDE.md

./ICT/Projects/Dual boot mijn Thinkpad/Dual Boot.md

./ICT/Hardware/Others/Eigen Tps/Deze is om een template te testen.md

./ICT/Windows/Windows/Utilities/I Use These Free Windows Tools to Find What’s Slowing Down My PC.md

./ICT/Windows/Windows/Utilities/These productivity tools go on every PC I set up without fail.md

 

Encountered something similar with grep output containing a <colon><space> combination (after 
"created") and thus removed from the value. Here I explicitly specified only the <tab> als 
delimiter but the <colon><space> combination is also treated as a delimiter (which in this case is 
helpful, but still not what I specified.)

Learning grep as well:  grep -rHT 'created: ' --include=\*.md . > ~/Documents/notes-created.txt

 

 

./ICT/Hardware/Computers/I significantly cut my PC’s boot time and it wasn’t from disabling startup 
apps.md: created: 2025-10-19

./ICT/Hardware/Computers/The best new computers to replace your old Windows 10 PC.md:     created: 
2025-10-12

./ICT/Hardware/Others/You Need These Hacks to Stop Your SSD From Dying Prematurely.md: created: 
2025-10-22

./ICT/Hardware/Others/USB Type-C en USB 3.1 (USB 3.2 genoemd) uitgelegd.md:     created: 2025-10-12

./ICT/Windows/Windows/The Easy, Free Way to Get Windows 11 on Your Old Computer.md:    created: 
2025-10-19

 

I expect that I do something wrong, - even? - MS-XL does this better

 

Regards, Hans Troost


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy