Hello @g-schick :),
No scripting necessary.
Nice, the list of the selectors for “Folder n” are automatically filled by Calc when it reads the hyperlinks. I didn’t know how it worked, very nice :).
These blob texts will follow a structure
What I call blob are the basenames “à tout faire”, where my mother adds any relevant information into the basename of the file.
Trust me, with typos included, you don’t want to script data extraction from this,
there will always be slight errors.
And no matter if you use AI or a simple script, you will always need a loop on all the files with a prompt like:
From the basename "blabla", the following metadata were extracted:
document type: invoice (Type '1' to correct)
invoice date: 2025/04/09 (Type '2' to correct)
invoice amount: 120 € (Type '3' to correct)
Type '4' to add another metadata.
Type '0' to validate.
Whatever strictly positive number you type,
you will see the same corrected prompt
to have the opportunity to make further corrections.
The script may be written in a few hours.
But it will take an huge amount of time to loop on all the files.
Around 50 000 files, I know why I talked about entry cost.
Fortunately, the number of basenames needing to be shortened was much less.
Best regards,
Laurent Lyaudet