Information générale
Catégorie:
Codage, syntaxe et commandes
There are quite a few ways to do this
The crudest way could be
lcTxt=strtran(_cliptext,chr(9),',') && covert the xl tab chars to commas
strtofile(lcTxt,'myfile.txt')
sele mytable
append from myfile.txt delim
or
to get more control you could use the ALINES function to pu all the lines into an array and then just parse the array a line at a time. Or even just use the MLINE() function and do it a line at a time.
eg
lcTxt=_cliptext
for li = 1 to memlines(lcTxt)
lcLine=mline(lcTxt,li)
repl myfield1 with subs(lcline,5,6),myfield1 with subs(lcline,5,6) etc
next
I have not checked the above but it should give you some ideas
good luck
>I need to grab multi-line, multi-field text from the clipboard but don't know how to parse it with code.
>
>Basically, I'm thinking of having the user copy 2 columns of data from an Excel spreadsheet into clipboard and paste it into the database. I could use automation but the spreadsheet will have multiple worksheets so it makes things little more complicated.
>
>How can I paste what is in the clipboard in code? Something like:
>
>For Each "line" In "clipboardtext"
> Zipcode = Left(clipboardtext,5)
> Count = Val(Mid(clipboardtext,6))
>Next
Précédent
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