topic Re: Delete special character from string in Application Development and Automation Discussions

Delete special character from string

Former Member — Tue, 18 Dec 2007 09:17:08 GMT

Hello,

how cann i delete a speacial character from a dataset.

f.e. delete 'a' from 'AaAaBbBb' returns 'AABbBb'.

Best regards,

TomSd

Re: Delete special character from string

Wil_Wilstroth — Tue, 18 Dec 2007 09:19:18 GMT

Hi Thomas,

tp_output = 'AaAaBbBb'.

REPLACE 'a' WITH space INTO tp_output.

Your output will look like 'A A BbBb'.

Then you finally condense it to remove spaces.

CONDENSE tp_output.

And it will look like your desired result 'AABbBb'

Hope it helps you

Thanks

William Wilstroth

Edited by: william wilstroth on Dec 18, 2007 5:20 PM

Re: Delete special character from string

Former Member — Tue, 18 Dec 2007 09:24:23 GMT

Hi,

Check the code below:

v_string = 'AaAaBbBb' .

if v_string ca 'a'

replace 'a' with ' ' into v_string.

condense v_string with no-gaps.

endif.

regards

Kannaiah

Re: Delete special character from string

Former Member — Tue, 18 Dec 2007 09:24:33 GMT

hi,.

data:out(10).

out = 'AaAaBbBb'.

REPLACE ALL OCCURRENCES OF 'a' IN out WITH ' '.

write out.

Pls Reward with points......

Rgrds,

Kumaresh

Re: Delete special character from string

Former Member — Tue, 18 Dec 2007 09:26:04 GMT

hi,.

data:out(10).

out = 'AaAaBbBb'.

REPLACE ALL OCCURRENCES OF 'a' IN out WITH ' '.

write out.

Pls Reward with points......

Rgrds,

Kumaresh

Re: Delete special character from string

kesavadas_thekkillath — Tue, 18 Dec 2007 09:26:56 GMT

wk_var = ''AaAaBbBb'

replace all occurrences of 'a' in wk_var with space.

condense wk_var.

Re: Delete special character from string

Former Member — Tue, 18 Dec 2007 09:52:14 GMT

use REPLACE ALL OCCURENCES OF 'a' WITH ''.

This will do,,

Reward if it helps