Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any option to take out the " ´ " in qlikview and normalize
i have the word Facturación and the word Facturacion, AND I WANT A FUNCTION TO NORMALIZE, take out the ´ for alla words
what can i do?
thank you a lot
Fernando
Replace(Replace([text field],'á','a'),'Á','A')
kind regards,
Marty.
since you want to get rid of the accents, you will have than just one letter to "clean"
try using mapsubtring
mapsubstring('mapname', expr)
create a mapping table and use MapSubstring()
hope this helps
regards
Marco
something like
mapLetterNorm:
LOAD * Inline [
á, a
é, e
í, i
ó, o
ú, u
ü, u
];
table1:
LOAD MapSubstring('mapLetterNorm', sometext) as sometext
FROM yoursource;
hope this helps
regards
Marco
Hi Martyn, i put "á" as an example, but i do not know what would be the "´"
could be any letter
marco, would be difficult to creat a mapping table because i do not know what word would be affected and what word will have the acentuation code ("'´"
mapsubtring does not replace the whole word only the character you define
This function can be used for mapping parts of any expression on a previously loaded mapping table. The mapping is case sensitive and non-recursive. The substrings are mapped from the left to the right. Mapname is the name of a mapping table previously read by a mapping load or a mapping select statement (see Mapping). The name must be enclosed by single straight quotation marks. Expr is the expression whose result should be mapped by substrings.
Examples:
// Assume the following mapping table:
map1:
mapping load * inline [
x, y
1, <one>
aa, XYZ
x, b ] ;
MapSubstring ('map1', 'A123') returns 'A<one>23'
MapSubstring ('map1', 'baaar') returns 'bXYZar'
MapSubstring ('map1', 'xaa1') returns 'bXYZ<one>'
Hi,
one example:
mapLetterNorm:
Mapping
LOAD * Inline [
letter, norm
á, a
é, e
í, i
ó, o
ú, u
ü, u
];
table1:
LOAD sometext,
MapSubstring('mapLetterNorm', sometext) as sometextnorm
INLINE [
sometext
La función de script MapSubstring sirve para hacer corresponder (mapear) partes de cualquier expresión con una tabla de correspondencias previamente cargada. La correspondencia (o mapeado) es sensible a mayúsculas y no repetitivo y las subcadenas se asocian de izquierda a derecha.
En este ejemplo cargamos una lista de modelos de producto. Cada modelo tiene un conjunto de atributos que se describen mediante un código compuesto. Si utilizamos la tabla de correspondencia con la función MapSubstring podemos expandir los códigos de atributo en una descripción.
];
note that I forgot the mapping prefix and headers in the inline load of my first example ...
hope this helps
regards
Marco
Hi Fernando,
Then mapsubstring is the way to go.
Marty.