Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

getting an extract of a field

Hello everyone i need your help on something i have a field that kind of looks this way "xvi-0956LK-xva0OL" I need to create a new field from the old one where i only display the middle part " 0956LK". Thanks for your help PS: this need to be done in the edit script part not in the reporting part

4 Replies
msheraton
Contributor III

getting an extract of a field

=SubField('xvi-0956LK-xva0OL','-',2)

MVP & Luminary
MVP & Luminary

getting an extract of a field

Hi,

You can also try using

=TextBetween('xvi-0956LK-xva0OL','-','-')

Hope this helps you.

Regards,

Jagan.

Not applicable

getting an extract of a field

Hi,

SubField('xvi-0956LK-xva0OL','-',2) as NewField

Thx,

Regards,

Prasath

msheraton
Contributor III

getting an extract of a field

I guess you didn't read the first reply