how to

[rdsuperlike]

how to do:

from ert234.55, 342er.345 or TRW345.12345 get string before .

so i want ert234, 342er , TRW345 and so on.

[Oleg_Troyansky]

Use the function SubField(text, N) and set N=1

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

[petter · Accepted solution]

In a load statement in a load script:

LOAD

      SubField( aField , '.' , 1 ) AS BeforeDot

      .....

FROM

     .....;

In the application:

=SubField( aField, '.' , 1 )      in an expression in a chart

Or if you have the strings in variables:

=SubField( aVar , '.', 1 )

[krishna_2644]

see attached.