Answered
Help with Pre-Map script
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
0
Comments
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:
Hi Matt,
Thank you for your help.
Brian
Please sign in to leave a comment.