Forum Discussion
julienvdc
Helper III
4 years agoExtracting numbers or removing text between delimeters
Hey there friends,
I have a column that lists topics with their ID and display name that are used in posts on my website.
It looks like this:
I am trying to build a new column that would extract and list only the ID, seperated by a comma.
So for example if my column is: ID1/Diplay-name1,ID2/Diplay-name2,ID7/Diplay-name7, it would return this: ID1,ID2,ID7
So my guess would be to remove anything that is held between / ... ,
It seems simple but I am not sure where to start 😁
2 Replies
- julienvdc
Helper III
Hey thanks amitchandak I'll have a look.
I've also found this which is interesting: https://www.thebiccountant.com/2019/07/15/text-removebetweendelimiters-function-for-power-bi-and-power-query/