Purgechar ##65#

[#1]

Hello All,

I would like to know if the below will remove only the '##65#' or all '#', '6' and '5' values?

PurgeChar(ABCD, '##65#')

I need to remove just the '##65#' from my column ABCD.

Many Thanks,

Hasvine

[tamilarasu · Accepted solution]

Hi Hasvine,

Yes. It will remove '#', '6' and '5' from your field. You need to use replace function in this case.

Replace(FieldName, '##65#', '')

[Chanty4u]

try this

aa:

LOAD * INLINE [

   ABCD,sales

    a##65#, 1

    abbb##65#, 2

    ##65#b, 3

    c##65#, 4

    d, 5

];

LOAD *,

PurgeChar(ABCD,'#65') as new

Resident aa;

[Chanty4u]

Check this

[prat1507]

Hi hasvine

It will remove all the '#', '6' and '5' values. Better use replace(ABCD, '##65#','').

Regards

Pratyush