topic Re: strings in Application Development and Automation Discussions

strings

Former Member — Mon, 30 Jun 2008 14:12:52 GMT

Hi..

I have some strings in an internal table and i am using concatenate to get the strings in the following format.

Format : Mr^firstnamesecondname^middlenameage

now this middle name may not always exist for all records, and in that case i need a space in that section

Eg : Mr^ABCDEFGH^ ^33

At present my output is Mr^ABCDEFGH^^33, i want it the above way

How can i traverse through the string till the third ^ and insert a space there..the first name n second name lengths vary with each record..

Re: strings

Former Member — Mon, 30 Jun 2008 14:17:55 GMT

Hi,

You can Try this.

Concatenate first two fields.

Before concatenating MiddleNAme write this.

if itab-middle is initial.

concatenate string itab-middle into string separated by space.

else.

concatenate string itab-middle into string.

endif.

That will definately help.

Reward if useful.

Sumit Agarwal

Re: strings

JozsefSzikszai — Mon, 30 Jun 2008 14:19:38 GMT

hi Rahul,

fiirst check is Middlename has any value, than CONCATENATE accordingly:

IF Middlename IS INITIAL.

CONCATENATE Mr firstname secondname space age INTO string SEPARATED BY '^'.

ELSE.

CONCATENATE Mr firstname secondname middlename age INTO string SEPARATED BY '^'.

ENDIF.

hope this helps

Re: strings

Former Member — Mon, 30 Jun 2008 14:30:08 GMT

Hi,

try this.

1. concatenate field 1 and field 2 into resulting string.

2. Check wheather exists or not by IF...ENDIF. block

If it exists then concatenate it or else do nothing. DON'T CONCATENATE SPACE , AS TRAILING SPACE IS NOT CONCATENATED . SO TAKE A FLAG VARIABLE AND SET ITS VALUE 1 (INITIALY KEEP IT IN 0).

3. If FLAG = 0 ---> concatenate age

elseif Flag = 1 --> concatenate space age to the resulting string.

it will defenitely work.

revert me for any doubt.

Reward if found helpful.

Anirban Bhattacharjee

Re: strings

Former Member — Mon, 30 Jun 2008 14:44:47 GMT

Hi...

I am using this

if itab-middle is initial.

concatenate 'Mr' Firstname secname SPACE age into text.

else.

concatenate 'Mr' Firstname secname middlename age into text.

endif.

And guess what my output doesn still have the space!!!

I tried replacing SPACE by ' ', still no luck!

Re: strings

Former Member — Mon, 30 Jun 2008 14:48:05 GMT

plz see my response below

Re: strings

Former Member — Mon, 30 Jun 2008 16:54:20 GMT

Hello Rahul,

you can try this way..

concatenate 'Mr' Firstname secname into text.
concatenate text age into text seperated by space.

Hope this works for you

Regards

Indu.