Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

chadliagabsi
Contributor II

TextBetween to eliminate one number

Bonjour,

Comment pourrai je utiliser textbetween pour prendre que 4chiffres de l'attribut suivant TextBetween Date(Date#(ADDTEN, 'DDMYYYY'), 'YYYY') c'est à dire je dois supprimer le 1er chiffre et prendre les 4.

1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: TextBetween to eliminte one number

Hi,

You use Mid() instead TextBetween

Mid(Date(Date#(ADDTEN, 'DDMYYYY'), 'YYYY'),2,4)

Regards,

Antonio

1 Reply
antoniotiman
Honored Contributor III

Re: TextBetween to eliminte one number

Hi,

You use Mid() instead TextBetween

Mid(Date(Date#(ADDTEN, 'DDMYYYY'), 'YYYY'),2,4)

Regards,

Antonio