Hi All,
I have a requirement to populate two columns in table control from excel using clipboard. (Copy two columns from excel and then, click on a button on the screen and table control's two columns should be filled).
I am using FM CLPB_IMPORT to get clipboard values.
eg: I am getting clipboard values as val1#val2
val3#val4
where each row is a row in excel and # indicates the columns.
The problem here is that I am not able to split val1 and val2 using the SPLIT statement using # character.
Any ideas will be appreciated.
Regards,
Arun Mohan