Topic Options
Rate This Topic
#95503 - 02/02/04 04:25 AM Zero filling a Numeric field?
david_boylan Offline
newbie

Registered: 03/11/04
Posts: 31
I have a numeric field that I use and increment by one. I need to display
it as a 3 digit field even if the value is 1. I.e., 001. Does anyone else
do this?


Dave




Top
#95504 - 02/02/04 04:57 AM Re: Zero filling a Numeric field? [Re: clementous_clement]
christoph albrecht Offline
Stealth Member

Registered: 02/01/02
Posts: 87
Hi Dave

You are able to do this. Copy your integer field to a display only
character field. Use LPAD($field$,3,"000") within the set field.

You are able to do this set field in a filter fireing on Get Entry. The
display only field will show your data in Modify Mode or in any reports.
Data is not avaible in table fields or result list.

If user have permission to change this field it is more complicated, I
think. Perhaps it is possible to Copy a "001" String to an integer field, I
do not know. Type conversion is not a strength of Remedy ARS.

Best Regards
Christoph




Top


Moderator:  Matt Reinfeldt