Gibraltar WhatsApp Full-Format Screening Tutorial

Gibraltar mobile phone numbers: remember these three points first

The Gibraltar International telephone code is+350, local numbers are unified as8 digits, excluding pre-order 0. Written in international format350 followed by 8 bits, for example+35020071234； Public information shows that most landline phones are made by200At the beginning, most mobile numbers are marked by5The beginning. When cleaning, first remove spaces, brackets, and lines, then remove the00Replace with+, eventually unified as+350XXXXXXXX。

Gibraltar country code and number length

Project	Value
International area code	+350
Local number length	8-digit numbers (excluding country codes)
Including the full area code	11-digit number (350 8 digits)
A typical prefix for a landline	200 (public information)
A typical prefix for mobile phones	5 (Public Information)
Preface 0	None

Gibraltar upgraded its local numbers to 8 digits in October 2003; the previously used 5-digit old numbers are no longer included in the current dialing rules. The specific number band allocation is managed by Gibraltar’s regulatory authority. When determining the ownership of a number range in bulk, it should refer to an authoritative number database or operator data.

International format versus local format

• Local dialing: Within Gibraltar, dial an 8-digit number directly, such as:20071234、54000000。
• International dialing：+350An 8-digit number follows, such as+35020071234、+35054000000。
• Data storage:Unified save in E.164 format+350XXXXXXXX, without spaces, parentheses, or lines.

Type	Writing style	Explanation
Local format	200 71234	Domestic dialing is used
International Format (Showcase)	+350 200 71234	Country code 8-digit number
E.164 Storage format	+35020071234	Remove spaces and separators
Telecom dialing method	00 350 200 71234	Common international prefix spellings

Precedence 0, No. 0, and 00 international prefixes

• Preface 0: Gibraltar numbers do not have a leading zero. If it appears in the data020071234Numbers starting with 0 are usually mistakenly added following UK dialing conventions; when standardizing, the leading zero should be removed and supplemented+350, got it+35020071234。
• Number:E.164 standard requires international numbers starting with+The beginning.+It’s not a number, but an international access identifier, which is recommended to be kept when storing.
• 00 International prefix: Used by many countries for international long-distance dialing00Substitute+So0035020071234Give me+35020071234is the same number. When storing the database uniformly, the00Converted to+。

Original writing	Analysis	Standardized results
00350 200 71234	00 is an international prefix	+35020071234
35020071234	Missing number	+35020071234
020071234	Multiple preceding 0s, and missing country code	+35020071234

How to unify spaces, parentheses, and horizontal lines

Display format and storage format are not the same thing.

+350 200 71234、+350(200) 71234、+350-200-71234It’s just a different way to write the same number, but if not standardized, CRM or Excel will treat them as separate records, causing all subsequent deduplication and matching to fail.

Cleaning rules:Display can use a separator, and storage must be unified as+350XXXXXXXX。

In Excel, E 11 and lead zeros are missing

Gibraltar number35020071234It’s an 11-digit number, which can usually be displayed fully in standard Excel format. The most common scenarios for this issue are as follows:

• When importing CSV, it is treated as a number：0035020071234Introduction00Discarded, turned into35020071234, cannot be restored.
• The number exceeds 11 digits: For example, if a bit of zero is added during concatenation, Excel will display it as scientific notation, for example3.50201E+11。
• but the leniency is insufficient: Display####, just widen the column; it’s not data corruption.

Solution:

1. Set the cell to ‘text’ format before entering.
2. When importing CSV, use the “Data → From Text/CSV” import wizard to specify the number column as text.
3. Numbers that have become scientific notation are formulated=TEXT(A1,"0")Trying to restore it.
4. Don’t use a lead belt00directly perform numerical operations on the number column, first converting to text and then removing it00。

Cleaning of duplicate numbers and incorrect country codes

The order of deduplication is very important:Standardize first, then eliminate redundant。

+350 200 71234Give me+35020071234It should be the same number. If you arrange duplicates first and then standardize, the remaining spaces and separators will cause Excel to treat them as two different values, creating pseudo-duplication.

Common country code errors include:

• General+350Written down+44(United Kingdom), because Gibraltar is a British Overseas Territory;
• General+350Written down+34(Spain), because Gibraltar borders Spain;
• Local 8-digit numbers missing country codes are directly stored in the database;
• 00Give me+Inconsistent writing methods can result in the same number being recognized in two different formats.

Judgment tip: First, check whether the digits after the country code match the typical length of the country code. Taking Gibraltar numbers as an example, if the country code for a certain data point is+34, but if there are only 8 characters after it and the business note is ‘Gibraltar customer,’ it is likely a mislabeling and should be manually confirmed before correcting+350。

Gibraltar Number Standardization Process (Before/After)

1. Extracting numbers: remove spaces, parentheses, and lines,+Number.
2. Unified00Yes+：00 → +。
3. Remove preceding 0: If a local number starts with 0, delete that 0.
4. Supplement country code: 8 digits before the local number+350。
5. Verification: The final should be+350followed by 8 digits, totaling 11 digits; A typical beginning is:200(Landline) Or5(Move).
6. Deduplication: Performs uniqueness checks based on standardized E.164 numbers.
7. Output: Saved as required by CRM or API+350XXXXXXXX。

Raw data	Problem	Standardized results
+350 200 71234	Extra spaces	+35020071234
00350 540 00000	00 Prefix, space	+35054000000
020071234	Preface 0. Missing country code	+35020071234
+350-540-00000	Separated by horizontal lines	+35054000000
35020071234	Missing number	+35020071234
54000000	Local format, lacking country code	+35054000000
+34 54000000(Note: Gibraltar customer)	Suspected national code mislabeling	After manual confirmation, it was changed to+35054000000

All numbers above are format examples.

Old numbers and special cases

Before 2003, Gibraltar used 5-digit local numbers, later uniformly upgraded to 8 digits. If 5-digit numbers are still retained in the old table, do not fill in the digits by guessing “add 200 or 5” in front; instead, handle according to the operator’s number migration table for that year; If uncertain, mark the data as invalid to avoid contamination of the existing number database.

A list of common mistakes

• Write Gibraltar’s number as+44Or+34；
• Keep it at the same time00And+Two forms, not yet unified;
• Edit the lead directly in Excel00The number of these numbers leads to00Loss;
• De-deduplication without standardization, or standardization after deduplication;
• Set display format+350 200 71234Directly into the warehouse;
• Blindly fill in the positions for 5 old numbers.

Batch process Gibraltar numbers with tools

If dealing with a full batch of customer data, it is recommended to first generate a standardized list according to the above rules, and then perform deduplication, filtering, or verification. AppShai (AppShai) provides batch processing capabilities for scenarios such as number standardization, deduplication, and activation/active filtering. The official website is https://aipushai.io. Number cleaning is only applicable to owned or authorized data, so please comply with local privacy regulations and platform terms of use.

AppShai （AppShai）It is a globally leading number ecosystem processing platform, deeply integratedGlobal mobile number coverage, bulk number generation, intelligent deduplication, multi-dimensional comparisonCore capabilities, providing coverage for global enterprises and individual clients220 countries and regionsThe Number Checking and verification service.
The system is currently compatible with the following mainstream social and business applications, including:
WhatsApp、LINE、Telegram、Viber、Zalo、Signal、Facebook、Messenger、Instagram、Microsoft、Binance、iMessageetc.
We will continue to develop and support more platforms, please stay tuned.

The platform’s features cover all-dimensional filtering scenarios and supportEnable filtering, active filtering, interaction filtering, gender filtering, avatar filtering, age filtering, online status filtering, precise tag filtering, online duration filtering, power-on detection filtering, inactive number filtering, mobile device model filteringetc., meeting various business needs from basic to advanced levels.

We provideSelf-service screening mode, agency-operated screening mode, refined layering mode, and customized solution mode, flexibly adapting to the different usage scenarios of individual developers, small and medium-sized teams, and large multinational enterprises.

The core advantage lies inOne-stop integration of global mainstream application ecosystems, providing real-time high-precision screening results, helping you significantly reduce customer acquisition costs and improve global digital operation efficiency.