Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
xxcarlosxx
Contributor III
Contributor III

Sustituir Valores / Replace Values

Buenas tardes,

Quisiera me pudieran ayudar como puedo sustituir valores por otros, en cada columna  de mi excel, por ejemplo hay valores que son:

     > (7) = Debe quedar 7

     > ... (9) = Debe quedar 9, etc

Mi libro tiene en 120 y 200 columnas y no mantiene un orden, pero esto no pasa en todas las columnas, sólo en algunas, existe alguna forma de poder reemplazarlos? Gracias.

Google Translate:

::::::::::::::::::::::::::

Good afternoon,

Wish they could help me as I can substitute other values in each column of my excel, for example there are values that are:

      > (7) = Must be 7

      > ... (9) = Must be 9 etc

My book is on 120 and 200 columns and does not maintain order, but this does not happen in all columns, only some there any way you could replace them? Thank you.

1 Reply
MarcoWedel

maybe

PurgeChar(ColumnName, '()')

or

KeepChar(ColumnName,'0123456789')

or

TextBetween(ColumnName,'(',')')

?

hope this helps

regards

Marco