clipboard_import problem with separator

[Former Member]

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

[fabio_bozzipagoto]

are you sure it the separator is SPACE?

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

[Former Member]

Hi

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.

[Former Member]

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