Multiple values pasting from excel to Input box issue

[#1]

Hi All,

i have a issue Doing multiple selection pasting in Input box and searching using a button..

please find the attachment:

Excel File Like

ID

1

2

3

When i am copying this cells from excel and pasting in QV- Input box it's showing like "1  2  " Each cell ending with Double Spaces.

Can anyone help me this asap.

Thanks,

Surya.

[prieper · Accepted solution]

Think that you need to cover the linebreak as well.

Please try something like

'(' & REPLACE(REPLACE(REPLACE(TRIM('$(vSearchProduct)'), '  ', '|'),' ', '|'), CHR(10), '|') & ')'

Peter

[RonaldDoes]

Hi Surya,

I've tested this and found out that a combination of CR and LF work (with my Excel/QV12).

='(' & REPLACE(REPLACE(REPLACE(TRIM('$(vSearch)'), '  ', '|'),' ', '|'), CHR(10)&CHR(13), '|') & ')'

Please find the QVW attached.

[#4]

Hi Peter,

Thanks for your reply.. 

When i am Copy 1 and 13 and pasted in Input box it's not working..

Thanks.

Surya

[#5]

Hi Ronald,

Thanks for your reply.. 

When i am Copy 1 and 13 and pasted in Input box it's not working..

Thanks.

Surya

[RonaldDoes]

What does the text box say when you do so?

[#7]

you Just Give in input box "2  13  ". you will be know my issue ronald..

[RonaldDoes]

That gives the below result. Is that not what you are expecting?

[#9]

I want show green color of Product Name also.. Can you please help me .

[#10]

Product also need to associate with green color . We can see Input box as Product that's needs to be associated data...