how to Eliminate /,.,- in particular field?

[khasimvali85]

Hi Community,

how to eliminate /,-,. in the perticular field? i am used subfield and purgechar but not showing the actual output.

Example: i have field like Reason

Reason(field)

not there.

customer/not available

customer/call-rejected

rejected_calls.

my achivement is:

---------------------

Reason

not there

customernot available

customer call rejected

rejectedcalls

the above reasons i wanna eliminate /,-,_,.

when i use Subfield(Reason,'/') as Reason only eliminate '/'

and i used Purgechar also but only eliminate single '/'

How can i achive this?

[robert_mika · Accepted solution]

t1:

load * inline

[

Reason

not there.

customer/not available

customer/call-rejected

rejected_calls

];

final:

load

replace(replace(replace(Reason,'/', ' '),'_',' '),'-',' ') as reason

Resident t1;

drop table t1

[awhitfield]

Example Attached

[simenkg]

mapChars:

mapping load * inline [

From, To

/,

_,

.

];

Reasons:

load MapSubString('mapChars',Reason) as Reason

from reason......;

[khasimvali85]

Hi Robert,

This is exactly i need the output.

Thanks.

Regards,

Khasim.

[robert_mika]

You are welcome