Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Pad Left with Zeros in Formula Language

Posted on 2001-09-12
5
531 Views
Last Modified: 2013-12-18
In Lotus Notes R5 designer, we have a field that is defined as text, editable.  It represents a number.  We want it to be a full 8 characters, and if the user keys in less than 8 characters, we want to pad it automatically on the left with zeros.  Example: if user keys 12345, we want to automatically make it to be 00012345.  

What is the Formula Language (@...) command to pad left with zeros to a specific number of total characters?
0
Comment
Question by:blyons48
  • 2
  • 2
5 Comments
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 6476627
Write this code in Input translation of the field,
max := 8;
len := @Length(num);
@if(len >= max; @left(num;max); @Repeat("0"; max-len) + num)

~Hemanth
0
 
LVL 1

Accepted Solution

by:
SAK earned 50 total points
ID: 6476869
Try:
@Right("00000000"+inputfld;8)


SAK
0
 

Author Comment

by:blyons48
ID: 6477230
SAK...your solution did the trick...simple and effective...thanks!
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 6477694
What ?
0
 

Author Comment

by:blyons48
ID: 6482683
HermanthaKumar,
Ah!  I just tried your solution as well, and it works too, and even more sophisticated than SAK's simple one-line solution.  I guess I just jumped on the simpler looking one.  I apologize.  If I could somehow share the points between both of your good working solutions, I would.  But I've already submitted the Accept Answer.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question