Variabler Text Probleme

Hallo :wave:

Ich bin neu in diesem Forum und auch neu in Sachen Lasergravuren etc. und dem Programm Lightburn.

Ich möchte gerne variable Texte erstellen und habe eine CSV Datei erstellt mit zwei Spalten.

In der einen Spalte steht der Name und in der nÀchsten Spalte steht ein Datum.

Spalte 1 Spalte 2
Alexander 26.04.2025
Marie 26.04.2025
Peter 26.04.2025

Wenn ich bei Lightburn %0 eingebe und ZusammenfĂŒhren/CSV auswĂ€hle wird mein Text aus der Datei eingefĂŒgt.

Allerdings sieht es dann so aus:
Alexander;26.04.2025

und meine Zeile mit %1 verschwindet einfach.

Stattdessen soll bei %0 der Name stehen und bei %1 das Datum.

Wisst ihr eventuell wo der Fehler liegt?
Mit freundlichen GrĂŒĂŸen

I suspect that the csv file has an error; it may have been exported with ‘;’ as the delimiter. Open it up in notepad, and double check the delimiter is “,”

When I open the text file with Notepad it says:

Alexander; 10/20/2025

If I change it to:

Alexander, 20.10.2025 and then add it back to Lightburn it says the following:

The CSV file had an error in line 1.

What else can I do?

Try putting quote marks around the date. It may be seen as a number with two decimal points.

It was an error in your csv file. Not sure how you created it or made the change, but I input your data into a google sheet and saved as CSV. It works fine. Here is the corrected file for you.
Untitled spreadsheet - Sheet1.csv (59 Bytes)

Turns out European versions of excel default to semicolon for the field separator when exporting csv files. This is due to comma being used as the default numeric separator. I guess that makes sense, but the file format is comma separated values! Perhaps Lightburn can add an option for field separator in the variable text window, as Microsoft makes the change to the field separator either system wide, or buried 4 layers deep in menus.

Another option is to use LibreOffice, as it will always allow you to change the field separator on export, helpfully enough in the export window, rather that in an advanced regional control panel sub window.

1 Like

Many thanks for the answers!
I will try it out as soon as I have time and then get back to you. :+1: