Left/Right Function

[#1]

Hi All

Is there a function in Qlikview equivalent to SQL Left and Right function.

I have a "~" separator and would like to get values to the left of it.

1~08-24 should return 1

125~feb 28 should return 125

[Gysbert_Wassenaar · Accepted solution]

You can use the subfield for this with ~ as field separator. subfield('1~08~24', '~', 1) will return 1

[robert_mika]

Another Way

=TextBetween('~'&'125~feb 28','~','~')

[#4]

Hi,

You can use subfield as Gysberts said / you can use Left() like this

Left(Fieldname, Index(Fieldname, '~')-1) as FieldName

[Anonymous]

I often use the QV mid() function as simpler alternative to the QV left() and right() functions.

[#6]

Thanks a lot guys for the solution