How to remove characters in between of strings?

[harleen_singh]

Hello,

            my string is like this asa--sasfs

or it can be like this --asaa

or like this asdfa---

i want to remove this -- from my string.

how to do it??

thanks

Lavi

[kaushiknsolanki · Accepted solution]

Hi,

    You can use PurgeChar() function.

    like this.

    =PurgeChar ('ABC ---- PQR','-')

Regards,

Kaushik Solanki

[#3]

Hi,

use PurgeChar()

like

PurgeChar(<feildname>, '[chars to remove]')

HTH

Reg,

Shubhu

[its_anandrjs]

Hi,

You have to use Purgechar like this

=Purgechar( YourField, ' - ' )

or for multiple

=Purgechar( Purgechar( YourField, ' - ' ), ' ( ' )

Regards

Anand

[#5]

Hey Anand,

Is it possible to use the Purgechar function to delete characters from a string, without removing every similar character in that string?
Example:

Purgechar(Message, '_Chart: ')
This will delete every single _ , C, h, a, r, t, :, and spacebar from the 'message string'.

Is it possible to just erase the '_Chart: ' and keep the rest of the _,C,h,a,r,t,: in that string?

Thanks in advance!

[tamilarasu]

Ivo,

You can use replace function in that case.

Replace(Message, '_Chart: ', '')

[#7]

That worked, Thanks!

[tamilarasu]

Not a problem .

[syinarosely]

i have something to ask...

The original string is "saya suka makan nasi"

How do i remove "saya" and "nasi" in this context?

Please share