Re: how to use substr - Qlik Community

Report Inappropriate Content · ‎2017-01-24

Hi Friends,

I have substr function.

I have part_id(123456_786789) i need after _786789 value how can i get.

vinieme12 · ‎2017-01-24

For the above you can use

Subfield (part_id,'_',2)

Other string functions

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

vinieme12 · ‎2017-01-24

Or Mid(part_id, findoneof (part_I'd, '_'))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

MK_QSL · ‎2017-01-24

'_'& SubField(YourFieldName,'_',-1) as YourFieldName

or

as Vineet has suggested..

how to use substr