Forum Discussion
How to find specific data in conditional column
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, t...
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.
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.