Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Special character

Hi,

I want to you know if QV get a function to translate a set of characters to another set ?

For example I want to transform the value déjà to the value deja. I know i can use twice the REPLACE function, but I want to translate an entire word in one step.

Maybe someone has already write the script for french characters (éèêî , ...)

Thanks for your help

Jean-Jacques

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You could use MapSubstring like this:

CharMap:
MAPPING LOAD * INLINE [
from, to
é, e
à, a
]
;

data:
LOAD *, mapsubstring('CharMap', x) as y
;
LOAD * INLINE [
x
déjà
zeke
]
;

-Rob

View solution in original post

4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You could use MapSubstring like this:

CharMap:
MAPPING LOAD * INLINE [
from, to
é, e
à, a
]
;

data:
LOAD *, mapsubstring('CharMap', x) as y
;
LOAD * INLINE [
x
déjà
zeke
]
;

-Rob

Not applicable
Author

Well done Rob

I could now transform all french exotic characters.

Jean-Jacques

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Jean-Jacques,

Could you post your finished app with the list of translated characters to the Share Qlikview section? I'd like to have a copy.

Thanks,

Rob

Not applicable
Author

Rob

I've just post my app

'Geocoding & mapping my client file in France'

on Share section.

All your remarqs are welcome

regards

Jean-Jacques