How to find specific data in conditional column

[Anonymous]

Heya! Apologies for my lack of terminology I'm new to this app - I am having trouble with getting data from a column, Im trying to just get a specific bit of data from a line entry. So for example, there is a column and each line contains a whole number such as 12345 amongst the words. I want to bring just this data over to its own column - I have tried using conditional column by clicking 'contains' and writign in the information I want to pull, but it pulls in the entire line not just the whole number. Is there a way to tell Power BI to pull JUST the number from the line? Example:

1. Invoice 123456 for John Doe

2. Invoice 1234567 for John Doe

3. Invoice 12345678 for John Doe

Entering 123456 for exmaple, still seems to pull the entire line in not just the number.

Thanks 🙂 

[camargos88 · Accepted solution]

Hi @Anonymous ,

You can use it for a custom column:

Text.Trim(Text.BetweenDelimiters([Column1],"Invoice","for"))

This also works:

Text.Select(Text.Range([Column1], 2, Text.Length([Column1]) - 2), {"0".."9"})

It removes the number followed by dot and select only the numbers.