Good thing you asked on a Friday.... :-)
In one Set Fields, set $Character Field$ to:
RPAD(LEFT($Character Field$, (6 - LENGTH(TRUNC($Character
Field$))) + (LENGTH(TRUNC($Character Field$)) / 5)), 5, "0")
Hope that helps.
Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard
Bach
"Shoemaker, Gary" <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)"
<[email protected]>
09/12/2008 07:03 AM
Please respond to
[email protected]
To
[email protected]
cc
Subject
Help parsing a string in a set fields
**
I am trying to do set a field to specific format using the functions but
can not get exactly what I want. It is a 5 character string and needs to
end up as a 5 character string. The pattern is that I leave all leading 0
and pad right up to 3 - the number of leading 0 if leading is more than 1.
Any suggestion on this would be greatly appreciated.
12566 goes to 12000
11456 goes to 11000
10456 goes to 10000
09456 goes to 09000
08456 goes to 08000
00956 goes to 00900
00096 goes to 00090
00009 goes to 00009
However beautiful the strategy, you should occasionally look at the
results.
Sir Winston Churchill
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
*IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely for
the entity or individual to whom it is addressed. If you are not the intended
recipient, you should delete this message and are hereby notified that any
disclosure, copying, or distribution of this message is strictly prohibited.
Nothing in this email, including any attachment, is intended to be a legally
binding signature.
*
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
