Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

rdsuperlike
New Contributor III

how to

how to do:

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

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

1 Solution

Accepted Solutions
MVP
MVP

Re: how to

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 )

3 Replies
MVP
MVP

Re: how to

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

MVP
MVP

Re: how to

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
Valued Contributor III

Re: how to

see attached.

Capture1.PNG

Community Browser