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

Greetings,

If your data is in a text file, then Sheet > Import from file should do
the trick if you use fixed width fields (not delimited) where only one
field is defined. For the second group of files in your message, I
would try using delimited fields with the colon as delimiter. This will
create three columns where column 2 will contain "created"; the tow
others will contain the filename and the creation date.

I hope this helps.
Rémy.
Le jeudi 22 janvier 2026 à 21:14 +0100, ht.lists@gmail.com a écrit :
> 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