Forum Discussion
t0talz
8 years agoRegular Visitor
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 1PowerQuery is case sensitive.... now thats really frustrating, this is not stated in the function references...
1 Reply
- t0talzRegular Visitor
PowerQuery is case sensitive.... now thats really frustrating, this is not stated in the function references...