trim after a character

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
jacquie
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

trim after a character

Post by jacquie » Tue Mar 24, 2009 2:47 pm

How do I trim a field after a character in the field?____Candles/Light = Light__DOG/CATS = CATS ______Thanks, Jacquie
Top
kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: trim after a character

Post by kfleming » Wed Mar 25, 2009 8:39 am

You could use:__WORD(fieldname,"/",2)______Kathleen__R&R Support
Top
jacquie
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: trim after a character

Post by jacquie » Thu Mar 26, 2009 9:30 pm

I tried that and I get an error message "Invalid argument". I am using the assoc field in MOM.__
Top
kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: trim after a character

Post by kfleming » Mon Mar 30, 2009 10:54 am

Sorry, I reversed the arguments incorrectly.____Try:__word(ASSOC,2,"/")____Kathleen__R&R Support
Top
Post Reply

Return to “R&R ReportWorks Users”