Page 1 of 1
trim after a character
Posted: Tue Mar 24, 2009 2:47 pm
by jacquie
How do I trim a field after a character in the field?____Candles/Light = Light__DOG/CATS = CATS ______Thanks, Jacquie
=> RE: trim after a character
Posted: Wed Mar 25, 2009 8:39 am
by kfleming
You could use:__WORD(fieldname,"/",2)______Kathleen__R&R Support
==> RE: trim after a character
Posted: Thu Mar 26, 2009 9:30 pm
by jacquie
I tried that and I get an error message "Invalid argument". I am using the assoc field in MOM.__
===> RE: trim after a character
Posted: Mon Mar 30, 2009 10:54 am
by kfleming
Sorry, I reversed the arguments incorrectly.____Try:__word(ASSOC,2,"/")____Kathleen__R&R Support