Forum Discussion

EpicTriffid's avatar
EpicTriffid
Helper IV
3 years ago

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...
Need Help
Tutorial Requests
EpicTriffid's avatar
EpicTriffid
Helper IV
3 years ago

This picture might be a better example of the data I'll be using:

 

 

Ahmedx's avatar
Ahmedx
Super User
3 years ago

pls try

Text.Combine( List.LastN(
Splitter.SplitTextByCharacterTransition(List.Transform({1..47},Character.FromNumber) & List.Transform({58..127},Character.FromNumber),{"0".."9"})([Column1]),2))

  • EpicTriffid's avatar
    EpicTriffid
    Helper IV
    3 years ago

    No, I'm sorry, this doesn't help either. The ID can appear anywhere in the string, not just what I have shown above, hence needing to use R for the RegEx