Forum Discussion

t0talz's avatar
t0talz
Regular Visitor
8 years ago
Solved

Text Contains Token Eof Expected Error

Hi,

 

I can't make any clue of this error message... this function is so simple, I checked multiple times the syntax. Still don't understand how this formula is wrong (for creating custom columen in query editor):

 

 IF Text.Contains([Hostname], "myhost.com") THEN "1" ELSE "0"

 

The same result (error) with this code:

 

 IF (Text.Contains("abc", "a")) = true THEN 0 ELSE 1
  • PowerQuery is case sensitive.... now thats really frustrating, this is not stated in the function references...

1 Reply

  • t0talz's avatar
    t0talz
    Regular Visitor

    PowerQuery is case sensitive.... now thats really frustrating, this is not stated in the function references...