Solved: SUBFILED WITH SPACE - Qlik Community

chadliagabsi · ‎2017-06-15

Bonjour,

Je veux diffusionner un champs sur deux. Ce champs contient un nom et un prenom séparés par des espaces.

Comment pourrai je les séparer.

Voila mon essai:

subfield(LIBELLE,'',1) as MENOM ,

subfield(LIBELLE,'',2) as MEPRENOM ,

Merci

Anil_Babu_Samineni · ‎2017-06-15

utilisez ceci

subfield(LIBELLE,' ',1) as MENOM ,

subfield(LIBELLE,' ',2) as MEPRENOM , // subfield(LIBELLE,' ',-1) as MEPRENOM ,

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2017-06-15

utilisez ceci

subfield(LIBELLE,' ',1) as MENOM ,

subfield(LIBELLE,' ',2) as MEPRENOM , // subfield(LIBELLE,' ',-1) as MEPRENOM ,

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

chadliagabsi · ‎2017-06-15

Merci Anil il me manque seulement l'espace.