topic Re: Offsetting a String, Removing SPACEs in a string, CONDENSE?? in Application Development and Automation Discussions

Offsetting a String, Removing SPACEs in a string, CONDENSE??

Former Member — Wed, 10 Dec 2008 20:48:16 GMT

Hi Experts,

I hv a string and its value is= 'ABCDEF space1 space 2 space3 space4 GHIJKL'.......I mean, there r 4 spaces, I need to hv only 1 space between these..........these number of spaces are varies and the lenghth of string also varies........so, how can I get it? like 'ABCDEF space1 GHIJKL'

thanq

Re: Offsetting a String, Removing SPACEs in a string, CONDENSE??

Former Member — Wed, 10 Dec 2008 20:53:42 GMT

i got it by splitting

Re: Offsetting a String, Removing SPACEs in a string, CONDENSE??

Former Member — Wed, 10 Dec 2008 21:00:21 GMT

Either way:

REPORT.
data:text TYPE string VALUE 'abcd    efgh'.
CONDENSE text NO-GAPS.
CONCATENATE text+0(4) ' ' text+4(4) INTO text RESPECTING BLANKS.
WRITE text.

Re: Offsetting a String, Removing SPACEs in a string, CONDENSE??

Former Member — Thu, 11 Dec 2008 21:52:08 GMT

thanq

but, as i mentioned in my posting that, the SPACES are variable, they may b start from 3 CHAR or 4th or 5th!!

anyways thaq

Re: Offsetting a String, Removing SPACEs in a string, CONDENSE??

Former Member — Thu, 11 Dec 2008 22:40:07 GMT

hi,

i hv issue to see the complete page of SDN webpage.........I mean, am getting a width of 25.5 CM only, so, if i want to write reply, i need to go all the bottom to get scroll extreme right and then, move top, then, clicking the REPLY button..........but, in this course, am loosing my response/reply box!!

So, all u guys r gettign the same width(if so, why SAP did it like incomfortable, I guess this is a application of a net weaver) or some thing wrong with my laptop/browser-explorer(if so, How to correct myself) ??

thanq

Re: Offsetting a String, Removing SPACEs in a string, CONDENSE??

Former Member — Thu, 11 Dec 2008 22:47:56 GMT

This is the problem with every one.

Re: Offsetting a String, Removing SPACEs in a string, CONDENSE??

Former Member — Fri, 12 Dec 2008 01:38:35 GMT

ok, thanq.

Re: Offsetting a String, Removing SPACEs in a string, CONDENSE??

Former Member — Fri, 12 Dec 2008 03:07:36 GMT

Hi,

Please try the method below.

data: s1 type string,

str1 type string,

str2 type string,

. str3 type string.

s1 = 'ABCD EFGHIJ'.

split s1 at space into str1 str2.

condense str2 no-gaps.

concatenate str1 space str2 into str3.

This way, the output will always be 'ABCD EFGHIJ' irrespective of the number of spaces between the two.

Thanks!

Sandeep

PS: please mark all helpful answers