AnsweredAssumed Answered

Inserting a character into a field via script

Question asked by user on Dec 22, 2011
Latest reply on Jan 12, 2012 by andrewshirts

I have a phone number field in text format the numbers are all mushed together e.g. 1234567890 and looks terrible and is a pain in the ass to read. so my boss would like me to create a script for a 5,500 record database (# total records increases each month). What the script needs to do is insert a dash at the proper intervals. e.g. 123-456-7890 some numbers have extentions but those are deleted(no idea why). i've fiddling around with a set field content of a variable of the same record as the one that is being altered, then performing an insert based upon the length of the text since each dash will occupy the same spaces, the 4th and 8th, but i've been having difficulty. if Any one out there wouldn't mind pointing me in the right direction i'd be very grateful. god and Peace bless you this mery Christmas.