Import only desired chars

[#1]

Dear all,

i have a problem and I don't know to solve it

I have a database with a field with several codes writed manually without control

I want to import it, but only dessired chars (without replace). As Example:

First Data on field :A-4533 FB

Second Data on Field:A4533 FB

Third data:A 2533FB

I want to create a string and only import chars that are on that STRING:

String='ABCDEF....1234567890'

And then data is A2533FB

The other option is to do a replace map, but i don't kown with characters can I found on database.

Any solution

And, on replace map:

Is correct that one?

ReplaceMap_1:

MAPPING

LOAD * INLINE [

char replace

-

<- Is an space char - all change to nothing (delete char)

]

(

<- Is an space char - all change to nothing (delete char)

]

(

<- Is an space char - all change to nothing (delete char)

]

(

delimiter is ' '

)

;

[#2]

Hi

Did you have a look at the PurgeChar() function?

Regards

Juerg

[boorgura · Accepted solution]

You can use the PurgeChar() or KeepChar() functions.

That should solve your issue.

Sorry if I got your question wrong.