Extract ID out of a column

Sitraka_Forler
Sitraka_Forler Dataiku DSS Core Designer, Registered Posts: 2 ✭✭✭

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

Capture d’écran 2022-06-16 114034.png

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

Thanks

Tagged:

Best Answer

  • Jurre
    Jurre Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered, Dataiku DSS Developer, Neuron 2022 Posts: 115 ✭✭✭✭✭✭✭
    Answer ✓

    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!

Answers

  • Sitraka_Forler
    Sitraka_Forler Dataiku DSS Core Designer, Registered Posts: 2 ✭✭✭

    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
    Jurre Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered, Dataiku DSS Developer, Neuron 2022 Posts: 115 ✭✭✭✭✭✭✭

    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!

Setup Info
    Tags
      Help me…