Text.PositionOf() returning only '-1' in all cirumstances despite search term being present.

[tgardner]

Self explanatory I think. 

 Col

"test"  

Text.PositionOf("test", [Col]) -- returns -1

Error occurs with individual letters and spaces and all values in the column and in different tables. I'm honestly baffled.

Hopefully a simple oversight, any help would be amazing!

Thanks

[PhilipTreacy · Accepted solution]

Hi @tgardner 

The arguments are the wrong way around.  It should be 

Text.PositionOf([Col], "test"))

If you have it like this

Text.PositionOf("test" , [Col]))

and there is anything before the word test in the Col column, it'll return -1

Phil

---

If I answered your question please mark my post as the solution.

If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[tgardner]

What an embarassing oversight!

Thanks so much.

[FrankAT]

Hi @tgardner 

with your sample and description I get the following solution:

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)