Hi Gary,
Alright..here is the answer for
00956 goes to 00900
If the field you are using is called "Assigned To" then,
An active link with "Run If" of
('Assigned To' LIKE "00%") AND ( (NOT ('Assigned To' LIKE "000%")) AND (NOT
('Assigned To' LIKE "0000%")))
and the "If" Action(in sequence) should be
1. set fields
LEFTC($Assigned To$, 3)
2. set fields
RPADC($Assigned To$, 5, "0")
I hope you can figure out the last 2 scenarios now(tweaking the above one).
Being a newbie in remedy, I would like to know from rest of list if there is a
more optimized way of doing this (if it can be done with only 1 active link).
I hope this helps.
Thanks
Chintan.
--- On Fri, 9/12/08, Shoemaker, Gary <[EMAIL PROTECTED]> wrote:
From: Shoemaker, Gary <[EMAIL PROTECTED]>
Subject: Help parsing a string in a set fields
To: [email protected]
Date: Friday, September 12, 2008, 7:03 AM
**
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___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
