Search Results

aigles,

I will try yours out in a bit. I need some time to figure it out.


dr. house,

Anything after the first 10 numeric digits (or 12 with dashes) can be thrown away, such as line 1...

Your input:

XXXXX:YYYYY:ZZZZZ:(123)456-7890x84848
XXXXX:YYYYY:ZZZZZ:x12345
XXXXX:YYYYY:ZZZZZ:(987)-654-3210
XXXXX:YYYYY:ZZZZZ:73849
XXXXX:YYYYY:ZZZZZ:543 - 987 - 2106...

I think that would work for any of the crap encountered when a person has the full number and area code formatted in 20 different ways. The remaining issue is when they just have their extension...

I have a set of free-form phone numbers that are not uniform and I want to reformat them into a standard uniform string. These are embedded at the end of a colon seperated file built by a large nawk...

Input File:

1234567890123456789012345678901234
----------------------------------
11111 XXX xxxxx 6666666666
22222 YYY 2222222222
33333 AAA TTT xxxxx 9999999999...

Most excellent!

That works. Thanks!

Wow that works great. Looks like I need to read up some more on nawk.

One thing though. This is eliminating the rows from FileA that have the same A3 value but the unique A1. In other words, the...

:::::::::
::FileA::
:::::::::
A1-------A2--------A3---A4---A5--
=================================
AC5VXVLT-XX----------------------
B57E434--XXXX1-----MMMM-ZZZ--111-...