Forum Discussion
Solved
Check if column text contains values from another column and return the text
Dear everybody, I have two different sources and i would like to search for the project number from the second source in the account from the first source and return the project in the custom col...
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
You'll need to take a different approach for this but this line will do it (in a new custom column)
= let _account = List.Select(Text.Split([Account], "-"), each Text.Length(_) = 4) in
if List.Count(_account) > 0 then _account{0} else null
Regards
Phil