Forum Discussion
Check if column text contains values from another column and return the text
Hi cerebro
Yes, you can use Text.BetweenDelimiters to extract just the 4 digits between the - -
= Text.Select(Text.BetweenDelimiters([Account], "-", "-"), {"0".."9"})Regards
Phil
Hi cerebro
If your Account in Source1 always contains only one 4 digit project code (or none), then you can extract it using this. No lookup to Source2 needed.
= Text.Select([Account], {"0".."9"})
If the Account in Source1 might also contain numbers that are not Project Codes, you could use this which does check against Source2
= if List.Contains(Source2[Project],Text.Select([Account], {"0".."9"})) then Text.Select([Account], {"0".."9"}) else null
regards
Phil
thank you for the elegant solution.
Yes in fact, there are some other numbers that do not represent a project number and if you replace any letter with a number, the second formula doesnt work anymore:
Can you fix it? Thanks again!
Hi cerebro
Yes, you can use Text.BetweenDelimiters to extract just the 4 digits between the - -
= Text.Select(Text.BetweenDelimiters([Account], "-", "-"), {"0".."9"})Regards
Phil
sorry to bother you again, but could you please edit the formula that it returns a match even when the project number is not in the middle of the text string ? thanks again for your help!
