Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Well done Rob
I could now transform all french exotic characters.
Jean-Jacques
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
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