topic clipboard_import problem with separator in Application Development and Automation Discussions

clipboard_import problem with separator

Former Member — Thu, 18 Oct 2007 15:06:34 GMT

Hello specialists,

I am using the FM 'ALSM_EXCEL_TO_INTERNAL_TABLE' with little modification to read Data from an Excel-Sheet.

Everything was working fine but then the users where begining to put texts into Excel-Fileds with <ALT>>ENTER> in it, "because it is looking better" .

Now the FB 'CLPB_IMPORT' stopps getting Field-Data at tis point <ALT>>ENTER>,

OK no problem I am using now

CALL METHOD cl_gui_frontend_services=>clipboard_import

and receiving all Excel data.

But now I am getting a SPACE as separator between the Excel fields.

Tha is bad because there are fields with text AND SPACE between the words of course.

I have no idea what to do.

System is 46C Support Package 40 and GUI is 620/55

Regards Wolfgang

Re: clipboard_import problem with separator

fabio_bozzipagoto — Tue, 23 Oct 2007 18:25:30 GMT

are you sure it the separator is SPACE?

I use this method and the separator is '#'. This symbol neans SEPARATOR HORIZONTAL in ASCII

Re: clipboard_import problem with separator

Former Member — Tue, 23 Oct 2007 18:47:03 GMT

This method is to import raw data, so obviously it'll not help you.

Your user may need to put some extra effort in that case.

Either whenever he wants to export he needs to create a file with a delimiter and export that file you can control the delimiter file in your program or he needs to end every cell with a specific special character.

Some other alternatives are also there.

But whatever be the alternative some extra effor is required.

Regards

Surya.

Re: clipboard_import problem with separator

Former Member — Wed, 24 Oct 2007 13:20:58 GMT

Thanks for all.

I now was testing the problem on my laptop via VPN.

There I have GUI 640/23.

All is working with getting horizontal Tabs.

The customer have to update all GUI´s.

Regards Wolfgang