Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Tinika
Tinika asked in Computers & InternetSoftware · 1 decade ago

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!

Update:

mid doesn't seem to work, says it doesn't exist?

Sorry I am fairly new to this.

Update 2:

I got it figured out...substr()+"-"+substr() worked like a charm.

1 Answer

Relevance
  • lbarroqueiro
    Lv 6
    1 decade ago

    yoou can use mid to do this... mid(yourString,1,3) & '-' & mid(yourstring,4,3)&'-'&mid(yourstring,8,3)

Still have questions? Get your answers by asking now.