File: //home/robovet/mail/new/1661421075.M469194P3610218.host40.registrar-servers.com,S=4028,W=4114
Return-Path: <>
Delivered-To: [email protected]
Received: from host40.registrar-servers.com
by host40.registrar-servers.com with LMTP
id UH4lGxNGB2NqFjcAJ0Bl1A
(envelope-from <>)
for <[email protected]>; Thu, 25 Aug 2022 05:51:15 -0400
Return-path: <>
Envelope-to: [email protected]
Delivery-date: Thu, 25 Aug 2022 05:51:15 -0400
Received: from mailnull by host40.registrar-servers.com with local (Exim 4.95)
id 1oR9W7-00FElY-DF
for [email protected];
Thu, 25 Aug 2022 05:51:15 -0400
X-Failed-Recipients: [email protected]
Auto-Submitted: auto-replied
From: Mail Delivery System <[email protected]>
To: [email protected]
References: <[email protected]>
Content-Type: multipart/report; report-type=delivery-status; boundary=1661421075-eximdsn-884812173
MIME-Version: 1.0
Subject: Mail delivery failed: returning message to sender
Message-Id: <[email protected]>
Date: Thu, 25 Aug 2022 05:51:15 -0400
--1661421075-eximdsn-884812173
Content-type: text/plain; charset=us-ascii
This message was created automatically by mail delivery software.
A message that you sent could not be delivered to one or more of its
recipients. This is a permanent error. The following address(es) failed:
[email protected]
No Such User Here
--1661421075-eximdsn-884812173
Content-type: message/delivery-status
Reporting-MTA: dns; host40.registrar-servers.com
Action: failed
Final-Recipient: rfc822;[email protected]
Status: 5.0.0
--1661421075-eximdsn-884812173
Content-type: message/rfc822
Return-path: <[email protected]>
Received: from robovet by host40.registrar-servers.com with local (Exim 4.95)
(envelope-from <[email protected]>)
id 1oR9W7-00FElD-8u
for [email protected];
Thu, 25 Aug 2022 05:51:15 -0400
To: [email protected]
Subject: =?UTF-8?B?Um9ib3ZldCAgItCf0YDQuNCy0L7QtNC40Lwg0YHQv9C40YHQvtC6INGC?= =?UTF-8?B?0LXQu9C10YTQvtC90L7QsiDQsiDQv9C+0YDRj9C00L7QuiDQuCDQuiDQtdC0?= =?UTF-8?B?0LjQvdC+0LzRgyDRhNC+0YDQvNCw0YLRgyI=?=
X-PHP-Script: www.robovet.com/index.php for 124.41.213.200, 124.41.213.200
X-PHP-Filename: /home/robovet/public_html/index.php REMOTE_ADDR: 124.41.213.200
Date: Thu, 25 Aug 2022 09:51:15 +0000
From: Robovet <[email protected]>
Reply-To: [email protected]
Message-ID: <[email protected]>
X-Mailer: PHPMailer 6.5.0 (https://github.com/PHPMailer/PHPMailer)
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Sender: <[email protected]>
From: Donaldfuemi <[email protected]>
Subject: Приводим список телефонов в порядок и к единому формату
Message Body:
Приводим в порядок базу телефонных номеров клиентов 3-мя способами:
1. Нормализация телефонных номеров в Excel (B2 - это адрес ячейки с исходным номером)
=ПРАВСИМВ(ПОДСТАВИТЬ(ПОДСТАВИТЬ(ПОДСТАВИТЬ(ПОДСТАВИТЬ(B2;" ";"");"-";"");"(";"");")";"");10)*1
2. Нормализация телефонных номеров в Notepad++ через Regexp
Заменяем <>0-9\n|\r|\r\n] на ничего. (заменяем все символы кроме цифр)
Заменяем ^(?:\+7|8|7)(\d10) на +7$1
3. Нормализация телефонных номеров прямо в .txt файле через программу. Этим способом можно обрабатывать огромные списки в несколько миллионов строк.
https://my.mail.ru/admin1.ru/admin/video/_myvideo/1.html
--
This e-mail was sent from a contact form on Robovet (http://www.robovet.com)
--1661421075-eximdsn-884812173--