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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

split a string

Hi,

I want to split a string and need to take first word and save it like a row and also do these for teh second and third and fouth row

ex:

INCIDENTE.ACCESO.BLOQUEO DE CUENTA.DIRECTORIO ACTIVO

INCIDENTE  |ACCESO       | BLOQUEO DE CUENTA| DIRECTORIO ACTIVO

INCIDENTE  |APLICACION| NEWHOTEL                     | ACCESO

thanks

7 Replies
danielrozental
Master II
Master II

try subfield

subfield(FIELD,'|') AS SOMETHING

MayilVahanan

HI

Try something like this

=SubField('INCIDENTE.ACCESO.BLOQUEO DE CUENTA.DIRECTORIO ACTIVO','.',1) gives INCIDENTE

=SubField('INCIDENTE.ACCESO.BLOQUEO DE CUENTA.DIRECTORIO ACTIVO','.',2) gives ACCESO

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

THANKS, BUT I NEED THAT EVERY ROW SAVE IN A DIFFERENT FIELD LIKE:

CATEGORIA1

==========

INCIDENTE

REUQEIRMIENTO

CATEGORIA2

==========

ACCESO

APLICACION

CATEGORIA3

===========

BLOQUEO DE CUNETA

NEWHOTEL

.

.

.

I HAVE THIS FIELD LIKE THIS INCIDENTE.ACCESO.BLOQUEO DE CUENTA.DIRECTORIO ACTIVO, BUT I NEED IT  LIKE I MENTION BEFORE. PLEASE HELP ME

MayilVahanan

Hi

Load *,

SubField('INCIDENTE.ACCESO.BLOQUEO DE CUENTA.DIRECTORIO ACTIVO','.',1) as CATEGORIA1,

SubField('INCIDENTE.ACCESO.BLOQUEO DE CUENTA.DIRECTORIO ACTIVO','.',2) as CATEGORIA2

from table;

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

AND HOW CAN I PUT INCIDENTE AND REQUERIMIENTO IN CATEGORIA1???, BECAUSE IT RESULT BUT IT PUT THE CATEGORY EN DIFERENTS ROWS LIKE

CATEGORIA1

INCIDENTE

CATEGORIA2

REQUERIMIENTO

HOW CAN I PUT IT LIEK THIS

CATEGORIA1

INCIDENTE

REQUERIMIENTO

THANKS

MayilVahanan

HI

where you taken the value as  'REQUERIMIENTO' ? can  i know it?

If you want all values as single field?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Daniel & Mayil pointed you in the right direction. below are your strings and a few test strings...to get Category1 to have INCIDENTE, INCIDENTE2, INCIDENTE3, REUQEIRMENTO....In your app, where are you reading this string from ? If there are just a few lines you can put them in an inline table and use it like below...

Tmp:

Load * Inline [

String

INCIDENTE.ACCESO.BLOQUEO DE CUENTA.DIRECTORIO ACTIVO

INCIDENTE2.ACCESO2.Test2 DE CUENTA.DIRECTORIO ACTIVO2

INCIDENTE3.ACCESO3.Test3 DE CUENTA.DIRECTORIO ACTIVO3

REUQEIRMIENTO.APLICACION.NEWHOTEL.DIRECTORIO ACTIVO4

];

Categories:

Load

Subfield(String, '.',1) as Category1,

Subfield(String, '.',2) as Category2,

Subfield(String, '.',3) as Category3,

Subfield(String, '.',4) as Category4

Resident Tmp;

Drop Table Tmp;