Hi,

I need strtran function in VB, e.g. I want to produce 200302021555 (3:55 = 1555). What's the simplest way to achive it?

>There is just one problem with this: this is the VB forum :)
>
>
>>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