Page 1 of 1
Formula with fields with special characters
Posted: Thu Apr 27, 2023 6:39 am
by jasc
Hi there
how do I create a formula for a filed with the name "VFAS(V)"
I need the formula
cell=VFAS(V)/6
but he always complains. Using " or ' doenst help either because he now says I would use a string
How do I do it ?
Regards
Jan
Re: Formula with fields with special characters
Posted: Wed May 03, 2023 12:58 pm
by Waveworks
Hello Jan,
First of all, terribly sorry for the delayed response. For some reason I didn't get an email notification.
Yes it's a bit complicated to use formulas with a column whose header contains non-alphanumeric characters. To get around this problem, first go into File -> Preferences -> CSV Import and make sure that Warn for invalid variable names is enabled. Then close and open your CSV file again. Now when your CSV file is loaded, a message will be printed in the message view informing you about the variable name you should use in formulas. Probably for VFAS(V), the variable name would just become VFASV, so your formula should be written cell=VFASV/6.
If this doesn't help, please let me know what error message you're given. You may also find hints in Help under Formulas and Expressions, which lists all error messages and some tips for how to resolve them.
Best regards,
Gustaf