I’m having a nightmare of a time and wondered if anyone could help. There’s probably (/hopefully) a really simple solution but I’m getting nothing.
I’m reading a number from Excel which could be a whole number (e.g. 1), a single number with a point (e.g. 1.5), or a double number with a point (e.g. 11.5).
The issue I’m having is working out when the number will have a single number or double number before the point. If the number has a point, it’ll be 16 characters long. If it doesn’t, it’ll only be 1 so I can’t do “If Length > 16” as it’ll always be 16 when I want to find out. The numbers before the point will always change, it could be 3, 43, 12, 24, anything.
Wildcards don’t work (e.g. If Variable.StartsWith("??.")…) so I’m stumped.
Can anyone offer a solution?