Need help with Foxpro function?
I need to inseert a character into a character string. Example: I have 1234567890 and I need to return 123-456-7890
Anyone know the correct funtion for this? Please and thank you!
I need to inseert a character into a character string. Example: I have 1234567890 and I need to return 123-456-7890
Anyone know the correct funtion for this? Please and thank you!
Anonymous
Favorite Answer
Hello
On this page you'll get
the requested information.
http://www.alvechurchdata.co.uk/foxtext.htm
KalaBandar
Try this
LEFT(<phoneno>, 3) + "-" + STREXTRACT(<phoneno>, 4, 7) + "-" RIGHT(<phoneno>,4)