topic Re: Replace String in Application Development and Automation Discussions

Replace String

Former Member — Thu, 16 Apr 2009 15:43:12 GMT

Hi all,

There are some string like these ;

aaa~~-bbb~~--ccc

aa~~bbbb~~---cc

aaaabbccc

.....

how can replace - or -- or ---or -

or -

with one space? Could you send me the algorithm?

Best regards,

Munur

Re: Replace String

anuj_srivastava — Thu, 16 Apr 2009 15:50:29 GMT

Hi Munur ,

you can use the command Replace all occurrences of.

let ur string be str = 'aabb-cc--'.

REPLACE ALL OCCURRENCES of '-' in str with space.

This can solve ur problem.

Regards,

Anuj

Re: Replace String

Former Member — Thu, 16 Apr 2009 16:03:00 GMT

use statement

Replace all occurence of '-' in <your field> with space.

If the above single statement gives you too many spaces use the following lines.

Replace all occurence of '----' in <your field> with space.

Replace all occurence of '---' in <your field> with space.

Replace all occurence of '--' in <your field> with space.

Replace all occurence of '-' in <your field> with space.

This will definitely serve your purpose.

Regards,

Lalit Mohan Gupta.

Re: Replace String

Former Member — Thu, 16 Apr 2009 16:16:29 GMT

Hi.

Use:

REPLACE ALL OCCURRENCES OF '-' IN str WITH SPACE.

and later, if you wish just ONE space,

CONDENSE str.

Re: Replace String

Former Member — Thu, 16 Apr 2009 16:37:12 GMT

Hi,

You can use regular expressions for that:

REPLACE ALL OCCURRENCES OF REGEX '-*' IN <your_string> WITH <replacement>.

This will replace caracters '-', '~~', '~~-', etc. in you string by the replacement string you specified.

Hope it helps.

Regards,

Tanguy

Re: Replace String

Former Member — Thu, 16 Apr 2009 16:52:33 GMT

Enough.

Rob