Forum Discussion
Extracting result of Regular Expression using R
Hi all, I've spent all day on this and don't feel any closer to achieving what I need. I don't really understand R or Python. I have a use case where I'm expecting to need to search a field for a...
your problem can be solved in Power query like this:
[ y =
Text.Contains([Column1],"55133025_Preq_1"),
to = if y= true then "55133025_Preq_1" else null][to]Hi Ahmedx
Unfortunately, this doesn't work as the ID I've used above is an example. I would expect it to change all the time. Hence the need for a regular expression.
you can specify how it will change and in which column it will happen
This picture might be a better example of the data I'll be using:
