I'm trying to copy a column of accounts from an Excel spreadsheet and paste it into a textarea input field in a WebFOCUS form. When I pass this textarea field, I get the following:
0 ERROR AT OR NEAR LINE 15 IN PROCEDURE _RHONDA9FOCEXEC
(FOC257) MISSING QUOTE MARKS: '26-26425
IBIF_ex = RHONDA9
QUERY STRING = IBIF_ex=RHONDA9&ACCOUNTS=%27&ACCOUNTS=26-26425%0D%0A26-25371%0D%0A22-31277%0D%0A26-16046%0D%0A26-27569%0D%0A26-11264%0D%0A&remLen=280
Account 26-26425 is the first of 6 accounts passed. How can I either remove the opening quote for the string or place a concluding quote for the same string?

paste into notepad first, cleans it up of all the underlying xml, then copy again and paste into your form

Tried your suggestion Susanah, but it didn't seem to work

The first message was that a value was missing quote marks. Check to see that the first and last quote marks are present on all literal values.

I too would like to do this. GeraldCohen, are you saying that you cannot paste the selection from excel? Of course I can do something like '001', '002', '003'... but then I have to manually edit the format or have users do this *shudder*.

What would be nice, is if you could highlight a column in excel, and paste it as-is into a textarea and have it recognize it the same way you would a tab delimited file with a filedef.