Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
fkeuroglian
Partner - Master
Partner - Master

take out "´" and normalize

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

9 Replies
martynlloyd
Partner - Creator III
Partner - Creator III

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

kind regards,

Marty.

ramoncova06
Partner - Specialist III
Partner - Specialist III

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
Partner - Master
Partner - Master
Author

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

could be any letter

fkeuroglian
Partner - Master
Partner - Master
Author

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
Partner - Specialist III
Partner - Specialist III

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:

QlikCommunity_Thread_167780_Pic1.JPG

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
Partner - Creator III
Partner - Creator III

Hi Fernando,

Then mapsubstring is the way to go.

Marty.