If {drug_basic.drugname}like 'HOMECARE-*, CIVAS -*, CYTO - *' then mid({drug_basic.drugname}, 10) else {drug_basic.drugname} else
If {drug_basic.drugname}like 'CYTO - *' then mid({drug_basic.drugname}, 10) else {drug_basic.drugname}
I get the message - The remaining text does not a ppear to be...
If {drug_basic.drugname}like 'HOMECARE-*, CIVAS -*, CYTO - *' then mid({drug_basic.drugname}, 10) else {drug_basic.drugname} else
If {drug_basic.drugname}like 'CYTO - *' then mid({drug_basic.drugname}, 10) else {drug_basic.drugname}
I get the message - The remaining text does not a ppear to be...
I have used this formula
If Fieldname like 'HOMECARE-*' then mid(Fieldname, 10, 50) else Fieldname
I would like to do this for multiple prefixes
If Fieldname like 'HOMECARE-*, CIVAS-*' then mid(Fieldname, 10, 50) else Fieldname
but this doesn't work
Any ideas?
Joanne
Group on formula
@Group
If Fieldname like 'HOMECARE-*' then mid(Fieldname, 10, 50) else Fieldname
Change 50 for max length of fields, if name not that long dont worry formula will only bring back what is there.
Ian
This worked fine
Thank you
Joanne
Yes there will always be a dash, but there may be other maedicines with a dash in.
The unique identifier to these rows is the prefix HOMECARE-
The field name is drug_basic.name
Thanks for the reply
The data is always prefixed by the word homecare-
So the data looks like
Homecare-apple
Apple
Homecare-banana
Banana
The actual data is medicines but didn't want to lists meds in a post
I have a report with the field fruit.basic.name which produces a list of fruits and how much has been sold, as below. I would like to merge alike rows
Red apples. 12.57
Green apples. 8.76
Large bananas 4.56
Small bananas 3.47
Long bananas 1.34
I would like it to look like this
Apples...
Just to let u know I have found the answer - Find and delete the cmdui.prf file for FrontPage - this is the file that stores your customizations and preferences for the FrontPage Menu and it will get rebuilt, using the defaults, the next time you start FrontPage.
When I try to open files in Microsoft Frontpage, the system starts loading, then it won't finish. When trying to end task, system brings up white text box that states "System is dangerously low in resources." I have seen replies on this forum about the same problem in word and you...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.