Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Dbase Expressions in Lookup.ini

Status
Not open for further replies.
greyone

greyone

Programmer
Dec 14, 2000
200
CA
I have a system field which i want to format it when a user enters anything. The format is as follws:
xx-xxxxxx
where if the user types in 1234 the lookup.ini updates the field to 00-001234.

Is this possible. Please suggest
 
Sort by date Sort by votes
Hi,

Yes you need the PadL and left commands

[AutoUpdate]
UFIELD1=UFIELD1

[UFIELD1]
Otherwise=&Left(padl(trim(contact1->phone2),8,"0"),2)+"-"+right(padl(trim(contact1->phone2),8,"0"),6)
Overwrite=1


Regards,

Richard.
PRIOR Analytics UK
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SerPan
  • Locked
  • Question
Search a contact in two contact sets
Replies
0
Views
93
SerPan
SerPan
NRGeti
  • Locked
  • Question
Detail tab in contact menu changed to table format
Replies
1
Views
127
goner
goner
NRGeti
  • Locked
  • Question
Missing zip code in field linked to Word
Replies
4
Views
139
NRGeti
NRGeti
codelphi
  • Locked
  • Question
adding additional search parameters in the Power Search function
Replies
0
Views
81
codelphi
codelphi
codelphi
  • Locked
  • Question
Looking for the source of LASTUSER value in CONTHIST
Replies
2
Views
119
DJHunt
DJHunt

Part and Inventory Search

Sponsor

Back
Top