Mon Oct 25, 2021 1:11 am
Login Register Lost Password? Contact Us


Do we have inbuilt telephone number parser in HPCC?

Questions around writing code and queries

Mon Nov 07, 2016 7:36 pm Change Time Zone

Hello,

I'm working on parsing a telephone number in the data to format the numbers and represent them in one common standardized format for a particular country/locale.

Just curious to know if there is any inbuilt package available to parse these telephone number and convert them to standardized format?

Your help is appreciated.

Thank you.
-Nilesh Chavan.
nileshdchavan
 
Posts: 22
Joined: Thu Mar 27, 2014 11:43 pm

Tue Nov 08, 2016 3:28 pm Change Time Zone

Nilesh,

AFAIK, there is no such standard parser included in the HPCC/ECL platform. You can use ECL's PARSE function to create one.

But if you're working within the RELX Group, then you should ask your HPCC/ECL colleagues if they've already written one that you can use.

HTH,

Richard
rtaylor
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 1600
Joined: Wed Oct 26, 2011 7:40 pm

Mon Dec 19, 2016 2:51 pm Change Time Zone

I used to use RegexBuddy https://www.regexbuddy.com/ to get my regular expressions straight, now I just use HPCC's REGEXFIND directly.

There is detailed information out there on parsing telephone numbers, try this http://blog.stevenlevithan.com/archives/validate-phone-number/comment-page-2 for a start.
Allan
 
Posts: 442
Joined: Sat Oct 01, 2011 7:26 pm


Return to Programming

Who is online

Users browsing this forum: No registered users and 1 guest

cron