Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

mario-sarkis
Contributor

indexing

Dear,

hope that you can help with this,

I have a field looks like this :

Input:

1|225536

11|31256323

13|54335

2|55363

I need the output field in the script all numbers before " | " in this case the output will be

1

11

13

2

Thank you

1 Solution

Accepted Solutions
b_knuever
Contributor III

Re: indexing

subfield(Input,'|',1)

2 Replies
b_knuever
Contributor III

Re: indexing

subfield(Input,'|',1)

stabben23
Honored Contributor

Re: indexing

use subfield, =subfield(Input,'|')

Community Browser