Field Count

2011-10-18 Thread Brittain, Mark
Hi All, I need to count the number of characters in a field, place the number in another field and then run workflow based on the number. Can't come up with the right function combination. Any ideas greatly appreciated. ARS 6.3 patch 20 Thanks Mark Mark Brittain Remedy Developer NaviSite - A

Re: Field Count

2011-10-18 Thread Axton
Set Fields Integer Field = LENGTH($Char Field$) or LENGTHC, though I am not sure LENGTHC is available in 6.3. LENGTHC supports counting multi-byte characters as a single character. Axton Grams On Tue, Oct 18, 2011 at 10:10 AM, Brittain, Mark mbritt...@navisite.comwrote: ** Hi All, **

SOLVED: RE: Field Count

2011-10-18 Thread Brittain, Mark
Thanks Axton - looked at LPAD and LEFTC and missed it. Time for another cup of coffee. Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Tuesday, October 18, 2011 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Field Count ** Set

Re: Field Count

2011-10-18 Thread Chintan Shah
: Field Count ** Hi All,   I need to count the number of characters in a field, place the number in another field and then run workflow based on the number. Can’t come up with the right function combination. Any ideas greatly appreciated.   ARS 6.3 patch 20   Thanks Mark   Mark Brittain Remedy