To put a space between country code and number from a phone number field

Koyel Guha
Tera Contributor

Hi,

There is a Phone Number field in the hardware table with the number with no space between country code and number.

I am using a flow where I have to fetch the phone number value from hardware table and put a space between country code and number in a separate field to update the same in AD.

We have country code table where we have location wise codes.

Could you please help with the script to implement this requirement.

 

Thanks in advance.

 

 

 

3 REPLIES 3

FarukS
Kilo Contributor

This task combines a lot of useful concepts such as working with country-specific data, formatting strings dynamically, and integrating different data sources (like hardware and country code tables). It’s a practical example of how automation and good data management practices can streamline tasks that would otherwise be tedious and error-prone. Imagine the complexity of doing this manually across thousands of records – but with a good script, you just make one tweak, and your data is ready for AD integration, saving hours of manual work. Plus, it demonstrates how flexible and powerful scripting can be when you're dealing with data transformation!

I hope this helps with your project. Let me know if you'd like further assistance or have any additional questions!

FarukS
Kilo Contributor

This task combines a lot of useful concepts such as working with country-specific data, formatting strings dynamically, and integrating different data sources (like hardware and country code tables). It’s a practical example of how automation and good data management practices can streamline tasks that would otherwise be tedious and error-prone. Imagine the complexity of doing this manually across thousands of records – but with a good script, you just make one tweak, and your data is ready for AD integration, saving hours of manual work. Plus, it demonstrates how flexible and powerful scripting can be when you're dealing with data transformation!

Hi Faruk,

Can you help me with the script to implement this requirement or if you can some insights on how we can achieve this.

Thank You