Phone Format - Australian Landlines
I have used the following to format australian formats
Landlines can be in this format:
all above will convert to 03 9999 8888 except 99998888 (it remains the same)
I need this format to be either 9999 8888 or 03 9999 8888 - just need a gap between the 8 digits
I am still struggling to do this for each phone (i have four columns of numbers)
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.
@Carolyn the issue appears to be the fact that you are missing the branch exchange
so you could use a regular expression but in the absence of that, if you still wanted to use the phone library you could try a compound function that is comprised of three pieces and uses a couple of variables
note that this only works if the number without branch code is 8 in length
The end result is a large function thus
but results in
I noticed that you mentioned you have multiple columns. So a reusable function would be useful in this context.
I would create a reusable function where we can format the number into a national format and then handle the remaining formatting with the substring and concatenate function. You could add a length check if required here.
You can then apply the reusable function across all the different columns as required with the Transform step "quick function" capability.
you might also want to use a combination that combines length and valid national number check using an AND condition and of course still make it reusable!
Thanks for quick response. Based on above information l was able to work out a way to solve it. It was the above that got me there. Its not the same but it worked.
Would send steps but unable to add to comment, states lm over the limit
@Carolyn you might want to do your own post describing how you solved the problem ;-)
Thank you for your quick replies. I looked at all your answers and it helped me come up with the fix. I did it differently but the above helped me
How do l do that? I can only leave a comment and post
you could post a new discussion
Re-posted on behalf of @Carolyn
Thank you for your quick replies. I looked at all your answers and it helped me come up with the fix. I did it differently but the above helped me resolve it. I did the following:
@Carolyn cleverly done. Just out of interest. What application did you use to copy /cut the screenshot ?
I just used the snipping tool and cut and paste
Is there a better way?