Jun-02-2023, 08:43 AM
Hi,
I have data in an FTS5 sql table, but you can sql update it like any other table. (but no field types)
Say the table is called "abc", and has 3 fields (filename, freeText,register)
The table has 42.000 records;
The problem is in the filename, consider this:
VST-098.png should be VST-0098.png
VST-125.png should be VST-0125.png
VST-995.png should be VST-0995.png
VST-1289.png is ok, with 4 numeric digits.
So I have to test on the numeric part, if it's 3 chars, add leading zero.
Normally in python, a piece of cake, but inside an sql table, how to ?
If it's too complicated, I can also rename the 42.000 image files, maybe that is the wiser option?
thx,
Paul
Edit: the KISS solution is modify the filenames. 5 minute job.
I have data in an FTS5 sql table, but you can sql update it like any other table. (but no field types)
Say the table is called "abc", and has 3 fields (filename, freeText,register)
The table has 42.000 records;
The problem is in the filename, consider this:
VST-098.png should be VST-0098.png
VST-125.png should be VST-0125.png
VST-995.png should be VST-0995.png
VST-1289.png is ok, with 4 numeric digits.
So I have to test on the numeric part, if it's 3 chars, add leading zero.
Normally in python, a piece of cake, but inside an sql table, how to ?
If it's too complicated, I can also rename the 42.000 image files, maybe that is the wiser option?
thx,
Paul
Edit: the KISS solution is modify the filenames. 5 minute job.