In Excel I use the function
=REPT("Buprenorphine",ISERROR(SEARCH("Bupr",AT14087))=FALSE) to search column[Additives] for text Buprenorphine
- ISERROR(SEARCH("Bupr",AT14087))=FALSE - evaluates to TRUE. The Rept () function accepts TRUE as being equivalent to 1
In Power Query I have tried
=REPT("Buprenorphine",ISERROR(SEARCH("Bupr",AT14087))=FALSE) to search column[Additives] for text Buprenorphine
- ISERROR(SEARCH("Bupr",AT14087))=FALSE - evaluates to TRUE. The Rept () function accepts TRUE as being equivalent to 1
In Power Query I have tried
Text.Repeat("Buprenorphine(Text.Contains([additives],"Bupr")) but this returns an error. If I use Text.Contains([additives],"Bupr") this evaluates to true when Buprenorphine is found in [Additives] but the second parameter - repeat count - of Text.Repeat does not seem to accept TRUE as equal to one which occurs in Excel. How can I convert TRUE to 1 ? Thanks Steve ([additives] is formatted as text) |