Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.8K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
Need help with a formula changing phone format from (000) 000-0000 to 000-000-0000
Johnny DeVilla
08-03-2018 21:07
I want to display phone numbers on a report as 000-000-0000 instead of (000) 000-0000. I just starting ...
David Hawe
08-03-2018 22:19
This is how I would do it with a Formula-Text field: Substitute your phone number field with [Home ...
Johnny DeVilla
08-06-2018 15:18
That did it, thank you for the help!!
Johnny DeVilla
08-06-2018 18:22
Would this Right(Left([File Path],"/")&"\" change my slashes in a file path to the opposite?
David Hawe
08-06-2018 21:04
I don't think so. It not really a search a and replace type of a function. If you have only one slash, ...
1.
Need help with a formula changing phone format from (000) 000-0000 to 000-000-0000
1
Like
Johnny DeVilla
Posted 08-03-2018 21:07
Reply
Reply Privately
Options Dropdown
I want to display phone numbers on a report as 000-000-0000 instead of (000) 000-0000. I just starting out with formulas any insight would be helpful.
2.
RE: Need help with a formula changing phone format from (000) 000-0000 to 000-000-0000
0
Like
David Hawe
Posted 08-03-2018 22:19
Reply
Reply Privately
Options Dropdown
This is how I would do it with a Formula-Text field:
Substitute your phone number field with [Home Telephone] and please see the strategic space in the embedded Right statement
Right(Left([Home Telephone],")")&"-"&Right([Home Telephone],") "),"(")
3.
RE: Need help with a formula changing phone format from (000) 000-0000 to 000-000-0000
0
Like
Johnny DeVilla
Posted 08-06-2018 15:18
Reply
Reply Privately
Options Dropdown
That did it, thank you for the help!!
4.
RE: Need help with a formula changing phone format from (000) 000-0000 to 000-000-0000
0
Like
Johnny DeVilla
Posted 08-06-2018 18:22
Reply
Reply Privately
Options Dropdown
Would this Right(Left([File Path],"/")&"\" change my slashes in a file path to the opposite?
5.
RE: Need help with a formula changing phone format from (000) 000-0000 to 000-000-0000
0
Like
David Hawe
Posted 08-06-2018 21:04
Reply
Reply Privately
Options Dropdown
I don't think so. It not really a search a and replace type of a function. If you have only one slash, you can concatenate what is left of it with what is right of it with an opposite slash in between. If there are multiple it gets much more complicated.
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic