Extract a string value from a URL

[swarnendu]

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. 

[rwunderlich · Accepted solution]

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

-Rob

[swarnendu]

Thank you Rob