Extract ID out of a column
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
Best Answer
-
Jurre Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered, Dataiku DSS Developer, Neuron 2022 Posts: 115 ✭✭✭✭✭✭✭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
-
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 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!
-
Your suggestion about using the "split column" processor is spot-on, especially if the URL structure is consistent. It’s such a clean way to isolate the ID without overcomplicating things. I’ve been tinkering with different ways to handle similar tasks, mostly for projects involving identity verification.
-
Recently, I explored tools like the Identity Verification API over at idanalyzer.com. It's pretty cool how these APIs can validate IDs directly from structured data, like URLs or uploaded files, saving time in workflows. Definitely not a one-size-fits-all solution, but it might come in handy if your project touches on verification needs.
