Information générale
Catégorie:
Codage, syntaxe et commandes
I am looking for a way to mimic the way "Append From" works with a comma delimited file, but instead of reading a text file, I am being passed a single string in this format.
In other words, if I am passed a string that looks like this:
"1234,'ABCDE',678,'FGH'"
What's the easiest way to break up that string into the appropriate fields of a table.
The only way I can think of to accomplish this, without writing the parsing code myself, is to write the string to a text file then use the APPEND FROM command to read it back in. There must be an easy way that won't produce needless drive writes.
Thanks
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement