Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld May 10-12, Online and Free! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
swarnendu
Creator II
Creator II

Extract a string value from a URL

I have a url field where i have product id .

I want to extract this product id  , i have use multiple function but i did not find appropriate output.

Example:    I have this type of value in my field i need to take only the value which is after 'featuredid='

1.     /category/62/play-load?featuredid=1018    

2.   /category/64/lotus-tomb?featuredid=1281&fascd=IwAR2ufaoyXoaOkG21a53yzjypP98rzjB0K7OIPAhI_CvfBesLoedCv_T0

3.   /category/64/lotus-tomb?featuredid=1693&fascd=IwAR04-VOsCY7zB1smhvS5hBE66-pYVjje06QDF5Fc_Vsdx4xrU84NN7kuUxA+aem_AV5lV-EVgm6TRludhNBfhuIzJyulli9LdM_KxHs3Ayl01WPNNDhWgRyFacDVNrUetkhEyxUdjW3JrzyPJGXFWeuOB-cLeYwcUfH0rsdiDmqaCou9O3eyM1yt04eRCuouubo

Expected Output(I need this)    1.   1018

                                                                2.  1281

                                                                3.  1693

Thanks in advance,

Swarnendu Haldar. 

Labels (2)
1 Solution

Accepted Solutions
rwunderlich

SubField(
SubField(yourfield, 'featuredid=', 2)
,'&', 1) 

-Rob

View solution in original post

2 Replies
rwunderlich

SubField(
SubField(yourfield, 'featuredid=', 2)
,'&', 1) 

-Rob

View solution in original post

swarnendu
Creator II
Creator II
Author

Thank you Rob