topic Re: String splitting at double hyphen while exporting from Spool to excel in Application Development and Automation Discussions

String splitting at double hyphen while exporting from Spool to excel

Former Member — Tue, 26 May 2009 09:05:31 GMT

Hi All,

My report output contains a string with double hyphen in one of the column of ALV. When i run the report in background and try to export the result from Spool to excel, the string is splitting into two separate columns.

eg: if the value is 123456--7 then, it will split into 1232456 in one column and 7 in another

Any idea to prevent this? please suggest a solution for this.

Regards

Sarath

Re: String splitting at double hyphen while exporting from Spool to excel

Former Member — Tue, 26 May 2009 09:10:16 GMT

Try to save the o/p in a notepad or in *.rtf format.

Copy and paste the data from notepad to xls sheet, ensure the columns in the xls sheet are Text formatted.

Regards

Vinayak

Re: String splitting at double hyphen while exporting from Spool to excel

former_member222860 — Tue, 26 May 2009 09:14:03 GMT

Hi,

Give a sigle quote ( ' ) in front of the string.

Just try if it works.

data: v_str type string.

v_str = '123456--7'.

if v_str CA '--'.

  CONCATENATE '''' v_str  into v_str.

endif.

write:/ v_str.

Mahesh

Re: String splitting at double hyphen while exporting from Spool to excel

Former Member — Tue, 26 May 2009 09:38:02 GMT

Thanks mahesh for the reply,

i tried this, it wont work

regards

Sarath

Re: String splitting at double hyphen while exporting from Spool to excel

Former Member — Tue, 26 May 2009 09:56:08 GMT

This might happen if you have already issued a "text to columns" in one of the excel sheets with delimiter option '-'.

Close all the excel documents and open a new excel sheet and try to copy the data.

Thanks,

Mahesh