take out "´" and normalize

[fkeuroglian]

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

[martynlloyd]

Replace(Replace([text field],'á','a'),'Á','A')

kind regards,

Marty.

[ramoncova06]

since you want to get rid of the accents, you will have than just one letter to "clean"

try using mapsubtring

mapsubstring('mapname', expr)

[MarcoWedel]

create a mapping table and use MapSubstring()

hope this helps

regards

Marco

[MarcoWedel]

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

[fkeuroglian]

Hi Martyn, i put "á" as an example, but i do not know what would be the "´"

could be any letter

[fkeuroglian]

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 ("'´"

[ramoncova06]

mapsubtring does not replace the  whole word only the character you define

mapsubstring('mapname', expr)

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

[MarcoWedel]

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

[martynlloyd]

Hi Fernando,

Then mapsubstring is the way to go.

Marty.