I want "text then g/kg/d" to be recognised as a string. How do I deal with the "/"?
Literal text should be quoted in calculation
Or, if you mean "field name" saying "record name",
(Using / in field name should alert you that)
Is char(47) a forward slash? ie. /
I dare say I'm being 'thick' but substituting char(47) for / in:
text then g/kg/d
just got a complaint that there was no such function.
Do you want to calculate drug dosage?
Is it (gram per kg per day) ?
Yes and what it appears you need to do if wanting:
recognised as script is to write:
I'd not have guessed 'char(47)' was a forward slash!!
for what end result? are you trying to make a "keyword" or search for the string or ??
Find 'g/kg/d' (no quotes) would find your record/field. As would finding by 'g kg d' (no quotes - note spaces).
The value "indexes" for value-lists.
More info, please!
I would suggest that you split those in different fields.
This will decrease the different possibilities you might have
g or mg or IU ...
Kg or m2
I'm trying to put certain values eg:
into a calculation that will be the basis of a value list. The record name (eg. Customise_individualise_gN2/Kg/d) has to be exactly as written to find the record, hence I need '/' to appear as such.
It was: list("Customise_individualise_gN2/Kg/d"; self)
that I was after but which didn't work. However, I'd not shown that I was copying a list of text strings from a Word processor and have found that a paragraph mark had between between my first " and the actual text. Simplistic mistake. The above method now works.
Retrieving data ...