Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    OH
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unformatting Text (2k)

    I have a database with a phone number formatted as (999)999-9999. I would like to export it via a query as 9999999999. In other words, remove the formatting. Can this be done in a query? Thx

  2. #2
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unformatting Text (2k)

    First determine whether the phone number is stored as (999)999-9999 or whether it is actually stored as 9999999999 by adding "0000000000" to the format property of the field in your query. Now run the query. If you get 9999999999 then all you have to do is export. If you get (999)999-9999 then you can use this formula to convert:

    : Mid([yourfield],2,3) & Mid([yourfield],6,3) & Mid([yourfield],10,4)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •