I need to convert phone number from a string, ie 3334445555 into a formatted number, (333) 444-5555 in order to match customer in NetSuite.
My input data is:
"data": [
{
...
"Store Phone Number": "3334445555",
....
}
]
I don't understand how to pull out the phone number, alter and then pass it.
Has anyone done this? Help is much appreciated.
Brian
Hi Brian,
This is Matt, head of Product at Celigo.
The following code iterates over each record in the data[] array and simply concatenates the pieces of the number with the additional characters. Hope this helps.
-Matt
Try this:
function convertPhoneNumber (options) {
options.data.forEach(function(i) {
let tmp = i["Store Phone Number"]
i.cleanNumber = "(" + tmp.substring(0,3) + ") " + tmp.substring(3,6) + "-" + tmp.substring(6,10)
})
return {
data: options.data,
errors: options.errors
}
}
The following sample:
{
"errors": [],
"data": [
{
"Store Phone Number": "3334445555"
},
{
"Store Phone Number": "1234567890"
}
]
}
Yields:
{
"data": [
{
"Store Phone Number": "3334445555",
"cleanNumber": "(333) 444-5555"
},
{
"Store Phone Number": "1234567890",
"cleanNumber": "(123) 456-7890"
}
],
"errors": []
}