Forum Discussion

PeteIannetta's avatar
PeteIannetta
Regular Visitor
4 years ago

Text.PositionOf not working

Hi, Up until the 3/9/21 I had a query that used the Text.PositionOf function to return the position of an underscore in a text field.   Since then, it's generating an error stating that an invalid ...
Need Help
ImkeF's avatar
ImkeF
Community Champion
4 years ago

Hi PeteIannetta ,
that looks like a bug to me and I would recommend to open a ticket.
With the sample you've given, I cannot reproduce the error, returning 7 for me.
So whatever transactions until this step happen might have created a special circumstance that leads to this "unlogical" behaviour.

 

PeteIannetta's avatar
PeteIannetta
Regular Visitor
4 years ago

Thanks Imke, the strange thing is that when I do a test of the functions, they show -1 whilst in PowerQuery in Excel, but when I load into Excel, it shows 7, so it seems to be working, I just can't get it to that point. I've had a look online, can't find where to log a Power Query support ticket, do you happen to have the link please?