Extract ID out of a column

Sitraka_Forler

Hello ,

I'm trying to extract the numbers after the / (but it's not always the first / ) and it's not the end of the url...

In exemple i only want the Bold number /33988-329055

I though an extract would work but it doesn't... Could anyone knows why ?

Thanks

Jurre

Hi @Sitraka_Forler
,

Although you mention that the number of interest is not at the end of the URl the slice of data shown hints otherwise.. if that is case then a "split column" processor, split on the "/" and truncate to the last column would leave you with that number. here is some reference to that.

Hope this helps!

Sitraka_Forler

Haha i tried before and it wasn't great but then i realised thanks to you that i could use extra steps and "voilà"

Thank you very much for your help! In the end it worked ^^

Jurre

Great! Taking a small detour or introducing helpersteps can definitely help although it might feel inefficient at first . Good thing is that we have a lot of options to choose from (or write our own!

cheers!