Import only desired chars

Fri, 21 May 2010 13:18:13 GMT

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 ' '

)

;

Fri, 21 May 2010 14:10:54 GMT

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

Regards

Juerg

boorgura — Fri, 21 May 2010 14:14:06 GMT

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

That should solve your issue.

Sorry if I got your question wrong.

topic Import only desired chars in QlikView