>I am trying reading a CSV using APPEND FROM, but the CSV contains a strange date format which cannot get recognized, any SET DATE I am trying does not work. In CSV it looks like this:
>
>2000-12-06
>
>Anybody has an idea to make the append work without the need to parse it line by line?
#1 Use regexp to manipulate the file to a format you need, read that.
#2 create a temp cursor that reads the column as character, manipulate that column, write back to disk, read result
#3 read to cursor as in #2, import from that cursor
#....
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]