Syntax Error: Invalid token (Commas being interpreted as decimals)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
30-04-19 03:49 PM
I get an invalid Syntax Error when trying to perform a Mid expression in a calculation stage, i.e., when evaluating Mid("United States", 8, 3), the the system reports that the token "0.80.3" is invalid. It seems to be interpreting the 8 and 3 as decimals. Please see the attached picture.
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-05-19 04:55 PM
This sounds like something to do with the locale setting of the PC where commas denote a decimal point. Maybe try experimenting with an English setting?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-05-19 01:58 PM
Hi,
Â
I have experienced this exact issue and the advice above is correct. You need to change your number formats in the local regional settings to use "." as decimal and not ",".
