[SOLVED] grep or awk search on line has no this format x-xxx-xxxx

I am with druuna... not sure why you would expect something to work on completely different formatted data?

@druuna - yes the --posix or --re-interval needed on gawk prior to v4

Dear Druuna
I truly appreciate your time and effort
and please be inform all the entries came as one line without \t which you thought on separate two line may its happen when i pasted here

Originally Posted by phpshell Dear Druuna I truly appreciate your time and effort and please be inform all the entries came as one line without \t which you thought on separate two line may its happen when i pasted here

If that is the case (single lines), then it works.

Using your input from post #14:

$ cat infile
70430031416@tel.net.sa     GigabitEthernet 0/0.1319:1319#587205380#TYP=INT;VID=0;NBR=PE-213-01-JAWARAH-10/1##pppoe e8:39:df:7c:4a:0d#2-280-3952#                                                                                                  
          
14260852@tel.net.sa                RY-DSL-HU03#7/0/0#MV120-00-348-DSWD9-D atm 1/1/08/20:0.35#tel.net.sa#5898-35ea-4d90#11-426-0852#                                                                                                                       
          
112788297@tel.net.sa               #ry-dsl-e9#MV172-00-309-UKALC-D atm 1/1/01/10:0.35#11-278-8297                            
                                                                                                                             
          
38406442@tel.net.sa                RY-DSL-HU02#1/0/0#AlJalawyah_JLWHEAAE-A_HiX5635_11_13#tel.net.sa#0025-69ae-60b3#3-840-6442#                                                                                                                            
          
26735218@tel.net.sa                GigabitEthernet 10/0.1788:1788#587205875#TYP=INT;VID=0;NBR=PE-209-01-MUSHRIFAH-10/0/18##pppoe 00:24:d2:73:de:c6#2-673-5218#                                                                                            
          
48402264@tel.net.sa                #jd-dsl-e6#IP422AALI-D atm 1/1/06/28:0.35#4-840-2264

$ awk --posix '/[0-9]{1,2}-[0-9]{3}-[0-9]{4}/ { gsub(/#/," ") ; print $1, $NF }' infile
70430031416@tel.net.sa 2-280-3952
14260852@tel.net.sa 11-426-0852
112788297@tel.net.sa 11-278-8297
38406442@tel.net.sa 3-840-6442
26735218@tel.net.sa 2-673-5218
48402264@tel.net.sa 4-840-2264

Originally Posted by grail @druuna - yes the --posix or --re-interval needed on gawk prior to v4

I expected as much.

Thanks for the confirmation!

No probs ... must be time you upgraded .. lol

My version works but assumes white space or # after last entry, so last line would need something like it.