Data Masking Function List

Search Knowledge Base by Keyword

< Back

The Data Masking functions are categorised logically, making it easier to browse them and find them. They can be used as simple functions, or combined in complex formulae.

Note: for some functions, the cell type must be set. For instance, generating dates requires the cell formatting must be set to the relevant date type. To format cells, right click the relevant cells and click “format cells”, before selecting the relevant formatting. Cell formatting further provides a greater degree of flexibility and increases the variety of data that can be generated using the data generation functions. The formatting can be specified for some functions within the formula itself, as specified below.

Note: The locale is set to the default US English (en_US) in the following examples, unless otherwise stated.

Numbers

Functions that mask integers.

Function NameDescriptionExample
VIP.Random.RandomDoubleReturns a random double value less than 1.=VIP.Random.RandomDouble()

Returns:
0.291310112
0.634659199
0.968867593
VIP.FormattedStringReturns a random string based on the format "# = Number, ? = Letter, * = Number or Letter".=VIP.FormattedString("# = 3, ? = A, * = 5")

Returns:
2 = 3, C = A, 7 = 5
6 = 3, L = A, 9 = 5
1 = 3, Q = A, 2 = 5
VIP.Random.RandomIntReturns a random integer value within a specified integer range=VIP.Random.RandomInt(1, 6)

Returns:
6
2
6
VIP.Function.IntSequenceReturns a random integer from a defined starting point, without duplicate values. The function is formatted =VIP.Function.IntSequence(sequence name, starting number). Integers will not duplicate within each given sequence name.=VIP.Function.IntSequence(1, 1)

Returns:
1
2
3
VIP.Function.LongSequenceReturns a random sequence from a defined starting point, without duplicate values. The function is formatted =VIP.Function.LongSequence(sequence name, starting number). Integers will not duplicate within each given sequence name.= VIP.Function.LongSequence(1,24)

Returns:
23
24
25
VIP.Random.RandomLong Returns a random, long and big integer value within a specified long range.=VIP.Random.RandomLong(1,50000)

Returns:
229432
33478
8765

Address

Functions that mask addresses and place names.

Function NameDescriptionExample
VIP.Address.BuildingNumberReturns a random building number.=VIP.Address.BuildingNumber()

Returns:
076
4583
5567
VIP.Address.CityReturns a random city name.=VIP.Address.City()

Returns:
Jacksonville
Nottingham
Milan
VIP.Address.CityPrefixReturns a random city prefix.=VIP.Address.CityPrefix()

Returns:
East
Port
Lake
VIP.Address.CitySuffixReturns a random city suffix.=VIP.Address.CitySuffix()

Returns:
Shire
Berg
Ham
VIP.Address.CountryReturns a random country.=VIP.Address.Country()

Returns:
Barbados
Fiji
England
VIP.Address.CountryCodeReturns a random country code.=VIP.Address.CountryCode()

Returns:
QA
JP
SM
VIP.Address.CountyReturns a random English county.=VIP.Address.County()

Returns:
Cambridgeshire
Buckinghamshire
Nottinghamshire
VIP.Address.FullAddressReturns a random full address.=VIP.Address.FullAddress()

Returns:

71186 Eichmann Gateway, North
Nayelishire, India
381 Emelie Ports, Schultzport, Nigeria
935 Mertz Spurs, Lake Ignacio, Niger
VIP.Address.LatitudeReturns random latitudinal coordinates.=VIP.Address.Latitude()

Returns:
61.9834
-69.9603
-64.8166
VIP.Address.LongitudeReturns random longitudinal coordinates.=VIP.Address.Longitude()

Returns:
-84.5083
-8.8659
-19.2732
VIP.Address.SecondaryAddressReturns a random secondary full address.=VIP.Address.SecondaryAddress()

Returns:
Suite 895
Apt. 548
Apt. 511
VIP.Address.StateReturns a random state.=VIP.Address.State()

Returns:
Orissa
Pondicherry
Jammu and Kashmir

When Locale is set to en_IND.
VIP.Address.StateAbbrReturns a random state abbreviation.=VIP.Address.StateAbbr()

Returns:
UT
OK
VA

When Locale is set to en_US.
VIP.Address.StreetAddressReturns a random street address.=VIP.Address.StreetAddress()

Returns:
Ängsvägen 15
Norra Åkergatan 862
Övre Järnvägsgärdet 720

When Locale is set to SV.
VIP.Address,StreetNameReturns a random street name.=VIP.Address.StreetName()

Returns:
Allée de Tilsitt
Rue de Seine
Passage Saint-Séverin

When Locale is set to fr.
VIP.Address.StreetSuffixReturns a random street suffix.=VIP.Address.StreetSuffix()

Returns:
park
straat
plantsoen

When Locale is set to nl.
VIP.Address.ZipCodeReturns a random zip code.=VIP.Address.ZipCode()

Returns:
TN01 2XU
YP23 1FE
UO8 1BQ

When Locale is set to en_GB

Company and Commerce

Functions that mask company and product information.

Function NameDescriptionExample
VIP.Commerce.CategoryReturns a random product category.=VIP.Commerce.Category

Returns:
Electronics
Automotive
Home
VIP.Commerce.ColorReturns a random product color.=VIP.Commerce.Color

Returns:
gold
yellow
ivory
VIP.Commerce.PriceReturns a random product price.=VIP.Commerce.Price(1,4,2,"$")

Returns:
$2.46
$1.78
$2.54

When the cell is formatted to currency, with the symbol “$” set.
VIP.Commerce.PriceParameterReturns a random product price, parameterized.=VIP.Commerce.PriceParameter(1,4,2,"$")

Returns:
$2.46
$1.78
$2.54

When the cell is formatted to currency, with the symbol “$” set.
VIP.Commerce.ProductReturns a random product type.=VIP.Commerce.Product()

Returns:
Salad
Chicken
Computer
VIP.Commerce.ProductAdjectiveReturns a random product adjective.=VIP.Commerce.ProductAdjective

Returns:
Sleek
Refined
Fantastic
VIP.Commerce.ProductMaterialReturns a random product material.=VIP.Commerce.ProductAdjective

Returns:
Sleek
Refined
Fantastic
VIP.Commerce.ProductNameReturns a random product name.=VIP.Commerce.ProductName()

Returns:
Generic Frozen Towels
Rustic Wooden Chair
Incredible Steel Mouse
VIP.Company.bsReturns a random piece of company jargon or management speak.=VIP.Company.Bs()

Returns:
generate next-generation relationships
scale e-business relationships
maximize ubiquitous markets
VIP.Company.CatchPhraseReturns a random company catch phrase.=VIP.Company.CatchPhrase()

Returns:
Implemented content-based moderator
Assimilated incremental Graphical User Interface
Down-sized object-oriented artificial intelligence
VIP.Company.CompanyNameReturns a random company name.=VIP.Company.CompanyName()

Returns:
Garnier - Perrot
Rosenbaum Group
Reilly – Hermann

When Locale is set to en_GB
VIP.Company.CompanySuffixReturns a random company suffix.=VIP.Company.CompanySuffix()

Returns:
Inc
Ltd
and Sons

Date

Functions for masking dates.

Function NameDescriptionExample
VIP.Random.RandomDateReturns a random date within a specified date range.=VIP.Random.RandomDate("1/1/1900", "7/19/2018")

Returns:
8/21/1900
2/4/1909
5/13/1989

When the cell formatting is set to number/date/*3/14/2012 and the locale is set to English (US).
VIP.Date.FutureReturns a random date in the future, with the number of future years specified in the format =VIP.Date.Future(number of years to go forward) . Note: the cell must be formatted to date, with the correct format. =VIP.Date.Future(4)

Returns:
10/27/2021
4/20/2022
8/15/2019

When the cell formatting is set to number/date/*3/14/2012 and the locale is set to English (US).
VIP.Date.MonthReturns a random month.=VIP.Date.Month()

Returns:
January
February
December
VIP.Date.MonthAbbrReturns a random month abbreviation.=VIP.Date.MonthAbbr

Returns:
Jan
Mar
Nov
VIP.Date.PastReturns a random date in the past, with the number of past years specified in the format =VIP.Date.Past(number of years to go back). Note: the cell must be formatted to date, with the correct format. =VIP.Date.Past(80)

Returns:
2/14/1950
4/25/1944
8/7/1979

When the cell formatting is set to number/date/*3/14/2012 and the locale is set to English (US).
VIP.Date.RecentReturns a random date within a number of days of the current date, specified in the format =VIP.Date.Recent(number of days). The number of days is set to 30 by default. Note: the cell must be formatted to date, with the correct format. =VIP.Date.Recent(5)

Returns:
9/6/2018
9/6/2018
9/5/2018

When the function is executed on 10/09/2018 and the cell formatting is set to number/date/*3/14/2012 and the locale is set to English (US).
VIP.Date.WeekdayReturns a random weekday.=VIP.Date.Weekday()

Returns:
Friday
Wednesday
Sunday
VIP.Date.WeekdayAbbrReturns a random weekday abbreviation.= VIP.Date.WeekdayAbbr()

Returns:
Tues
Sun
Mon

Finance

Functions that mask account, currency, and transaction information.

Function NameDescriptionExample
VIP.Finance.AccountReturns a random account number.=VIP.Finance.Account()

Returns:
84296305
23065655
16099530
VIP.Finance.AccountOfSpecifiedLengthReturns a random account number of a specified length.=VIP.Finance.AccountOfSpecifiedLength(12)

Returns 12 Digit Account Numbers:
005968327716
548027231195
818407984863
VIP.Finance.AccountNameReturns a random account name like Savings, Checkings and Home Loans etc.=VIP.Finance.AccountName()

Returns:
Savings Account
Personal Loan account
Savings Account
VIP.Finance.AmountReturns a random amount of money.=VIP.Finance.Amount()

Returns:
Credit Card Account
Savings Account
Personal Loan Account
VIP.Finance.AmountWithDetailsReturns a random amount within a range specified in the format =VIP.Finance.AmountWithDetails(minimum amount, maximum amount, number of decimal places).=VIP.Finance.AmountWithDetails(1, 1000,2)

Returns a random amount between 1 and 1000, and two decimal places:
265.53
259.83
954.03
VIP.Finance.BicReturns a random bank identifier code (Bic).=VIP.Finance.Bic()

Returns:
TOXECRZ1399
UOTUGNB1
TWJAGDQ1
VIP.Finance.BitcoinAddressReturns a random bitcoin address.=VIP.Finance.BitcoinAddress()

Returns:
3M0Z1F9R7Z79H04F9R5Y4KQ10634
3BS6SB09WYY9BK9BG6Y40CHCMJH4B7
1RS9Q8JY968NPLXNJY11Y21D57MXDE88WJ
VIP.Finance.CreditCardNumberReturns a random valid credit card number.=VIP.Finance.CreditCardNumber()

Returns:
6767-5069-6253-4893-027
6759-5377-4241-9170
3529-2124-4921-0837
VIP.Finance.Currency.CodeReturns a random currency code.=VIP.Finance.Currency.Code()

Returns:
USD
XTS
MOP
VIP.Finance.Currency.DescriptionReturns a random currency with a description.=VIP.Finance.Currency.Description()

Returns:
IRR
DKK
RWF
VIP.Finance.Currency.SymbolReturns a random currency symbol.=VIP.Finance.Currency.Symbol()

Returns:
£
TT$
?

Name

Functions that mask job descriptors and names.

Function NameDescriptionExample
VIP.Name.FirstNameReturns a first name.=VIP.Name.FirstName

Returns:
?
??
??

When Locale is set to ja
VIP.Name.FullNameReturns a full name.=VIP.Name.FullName()

Returns:
Ramon Karlsson
Amy Svensson
Neil Nilsson

When Locale is set to sv
VIP.Name.JobAreaReturns a job area.=VIP.Name.JobArea()

Returns:
Integration
Solutions
Group
VIP.Name.JobDescriptorReturns a job descriptor.=VIP.Name.JobDescriptor()

Returns:
Senior
Customer
Corporate
VIP.Name.JobTitleReturns a job title.=VIP.Name.JobTitle()

Returns:
Human Accounts Executive
Customer Directives Manager
Product Paradigm Assistant
VIP.Name.JobTypeReturns a job type.=VIP.Name.JobType()

Returns:
Dynamic Program Associate
Customer Paradigm Manager
Chief Applications Analyst
VIP.Name.LastNameReturns a last name.=VIP.Name.LastName()

Returns:
Ferrara
Costantin
Bianc

When Locale is set to it
VIP.Name.PrefixReturns a name prefix.=VIP.Name.Prefix()

Returns:
??????
?????
??????

When Locale is set to el
VIP.Name.SuffixReturns a name suffix.=VIP.Name.Suffix()

Returns:
I
Sr.
V

Phone and Internet

Functions that mask information relating to email, phone numbers, IP, URL, and online account details.

Function ListDescriptionExample
VIP.Phone.PhoneNumberReturns a random phone number, specified by the locale.=VIP.Phone.PhoneNumber()
Returns:

+910245048269
+912292980049
+91289-806-9090

When Locale is set to en_IND
VIP.Phone.PhoneNumberWithFormatReturns a random phone number, specified by the locale. Formats are specified within bracket and double quotation marks. Hash signs (#) will be replaced with a random number, and all other characters such as spaces, dashes, and bracket, will be replicated literally.=VIP.Phone.PhoneNumberWithFormat("(0)#### ######")

Returns:
(0)9238 323314
(0)8239 933496
(0)6060 966141

When Locale is set to es
VIP.Internet.AvatarReturns an online avatar.=VIP.Internet.Avatar()

Returns:
https://s3.amazonaws.com/uifaces/faces/twitter/nbirckel/128.jpg
https://s3.amazonaws.com/uifaces/faces/twitter/a1chapone/128.jpg
https://s3.amazonaws.com/uifaces/faces/twitter/traneblow/128.jpg
VIP.Internet.DomainNameReturns an internet domain name.=VIP.Internet.DomainName()

Returns:
samuel.es
clemente.info
patricio.info
VIP.Internet.DomainSuffixReturns an internet domain name suffix (".com; .net; .org").=VIP.Internet.DomainSuffix()

Returns:
es
org
info
VIP.Internet.DomainWordReturns an internet domain word that is used for domain names.=VIP.Internet.DomainWord()

Returns:
rosario
ramona
eva
VIP.Internet.EmailReturns an email address.=VIP.Internet.Email()

Returns:
Carolina42@gmail.com
Catalina_Galarza61@hotmail.com
Ramona23@gmail.com
VIP.Internet.EmailWithDetailsReturns variations of an email using a first name, last name, and provider, specified in the format =VIP.Internet.EmailWithDetails(“firstname, lastname, provider”).=VIP.Internet.EmailWithDetails("firstname", "lastname", "provider.com")

Returns:
firstname_lastname@provider.com
firstname.lastname77@provider.com
firstname_lastname59@provider.com
VIP.Internet.IPReturns an internet IP address.=VIP.Internet.Ip()

Returns:
222.88.182.155
55.114.248.110
134.228.149.234
VIP.Internet.IPv6Returns an internet IP V6 address.=VIP.Internet.Ipv6()

Returns:
ba3a:2ba4:b6b3:5360:f9a6:3747:95e2:504
803e:69ea:b832:c096:76d5:4d32:10:9685
146a:29ab:f04c:afa:2cab:8163:85d:2eb
VIP.Internet.MacReturns a Mac address.=VIP.Internet.Mac()

Returns:
3d:59:9f:a7:ab:07
87:c1:38:8e:8d:9d
a9:5c:91:4b:ed:ec
VIP.Internet.PasswordReturns a random internet password.=VIP.Internet.Password()

Returns:
fBUMRer2Wa
7n3Ku5RcHW
9enZAxmV_r
VIP.Internet.PasswordWithDetailsReturns a random internet password of a specified length.=VIP.Internet.PasswordWithDetails(6)

Returns:
lvTV5g
vJ2RvY
vWyLJX
VIP.Internet.ProtocolReturns a random internet protocol (http or https).=VIP.Internet.Protocol()

Returns:
http
https
https
VIP.Internet.URLReturns a random internet URL.=VIP.Internet.Url()

Returns:
https://lourdes.com
https://federico.com
http://jacobo.es
VIP.Internet.UserAgentReturns a random internet UserAgent.=VIP.Internet.UserAgent()

Returns:
Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_9_9 rv:6.0; BO) AppleWebKit/538.1.2 (KHTML, like Gecko) Version/4.1.6 Safari/538.1.2
Opera/10.22 (Windows NT 5.2; U; UR Presto/2.9.166 Version/12.00)
Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 5.2; Trident/6.0; .NET CLR 2.6.29901.2)
VIP.Internet.UserNameReturns a random internet UserName.=VIP.Internet.UserName()

Returns:
JoseEmilio_Valle
Daniela_Godoy94
Rosa.Cardona92
VIP.Internet.UserNameWithDetailsReturns a random internet UserName with details.=VIP.Internet.WithDetails(“first”, “last”)

Returns:
first.last22
first.last
first91

Linguistics and Text

Functions that mask basic linguistics and placeholder text.

Function NameDescriptionExample
VIP.Hacker.AbbreviationReturns an abbreviation for a random word.=VIP.Hacker.Abbreviation()

Returns:
IB
SAS
CSS
VIP.Hacker.AdjectiveReturns an abbreviation for a random word.=VIP.Hacker.Adjective()

Returns:
optical
open-source
optical
VIP.Hacker.IngVerbReturns a random '-ing' verb, a present participle.=VIP.Hacker.IngVerb()

Returns:
parsing
quantifying
indexing
VIP.Hacker.NounReturns a random word which, in this case, is a noun.=VIP.Hacker.Noun()

Returns:
pixel
driver
system
VIP.Hacker.PhraseReturns a phrase.=VIP.Hacker.Phrase()

Returns:
If we index the panel, we can get to the RAM panel through the redundant RAM panel!
VIP.Hacker.VerbReturns a random word which, in this case, is a verb.=VIP.Hacker.Verb()

Returns:
navigate
reboot
input
VIP.Lorem.LinesReturns several lines of filler text.=VIP.Lorem.Lines()

Returns:
Ut explicabo doloremque incidunt aperiam eum. Sed iusto repellendus cupiditate accusantium illum explicabo. Iure commodi veritatis beatae quis placeat id aut. Voluptatibus consequatur officiis sint quos nam cupiditate nemo reprehenderit.
Eaque qui id est hic cum. Iusto veritatis et hic eum. Cum est voluptatibus at nam consequatur. Quod vitae ad dolore accusantium a nobis quo. Quaerat numquam harum eos dolorum nobis doloribus possimus quis.
Ducimus ipsum rerum consequuntur doloremque quia qui et.
VIP.Lorem.ParagraphReturns a single paragraph of filler text.=VIP.Lorem.Paragraph()

Returns:
Libero rerum accusantium tempora minus tenetur quia ea. Doloribus asperiores officia nam et velit voluptatem ut. Doloribus minus modi similique provident tempore quis sunt eos. Numquam pariatur error odio. Deserunt sunt est. Necessitatibus qui accusamus in ut eos nihil vero. Ratione quo quo quia sed magnam doloremque. Aspernatur aut ex earum nesciunt illum. Eveniet molestiae omnis facilis. Non quo impedit suscipit delectus voluptatem et. Doloremque qui delectus molestiae et doloribus et quas facilis. Amet repudiandae harum.
VIP.Lorem.ParagraphsReturns paragraphs of filler text, the number of which is specified.=VIP.Lorem.Paragraphs(2)

Returns:
"Aliquam eligendi minus voluptates necessitatibus aliquam. Quo voluptatem non recusandae itaque officiis alias accusamus. Doloribus dolorem harum quasi quo iure excepturi. Eum perspiciatis rerum.
Commodi minus earum porro autem blanditiis. Ut aliquid reiciendis similique reprehenderit soluta illum numquam. Illo iste et est. Adipisci placeat repellat nihil placeat accusamus." "Et debitis sapiente. Id autem iste aut tempore distinctio ut error illum. Recusandae consectetur itaque qui laborum nihil aut iste voluptates quis. Sint a minima deleniti odit consequatur velit.
Repudiandae dolor maiores. Iure sit consequatur dolorem quasi illo omnis voluptatem eos. Quam veniam delectus ut consequatur." "Consequatur ut cum. Illum esse ad harum. Expedita consequuntur quia quisquam voluptatem possimus quia.
Et quam amet atque at cupiditate. Inventore qui vero velit qui. Voluptate ipsum inventore unde non enim."
VIP.Lorem.SentenceReturns a single sentence of filler text.=VIP.Lorem.Sentence()

Returns:
Odio dolorem unde alias officiis illo doloribus quia aut cupiditate.
VIP.Lorem.SentencesReturns sentences of filler text, the number of which are specified.=VIP.Lorem.Sentences(2)

Returns:
Autem enim debitis non quisquam deleniti. Labore quibusdam et. Quis aut facere.
VIP.Lorem.SlugReturns a random slug, the portion of the URL that specifies a resource, of length specified.=VIP.Lorem.Slug(4)

Returns:
iusto-et-autem-tempore
id-et-aut-enim
nostrum-repudiandae-est-officia
VIP.Lorem.TextReturns text on random lorem methods.=VIP.Lorem.Text()

Returns:
Sit voluptatem maiores libero error corrupti nesciunt. Numquam sit maiores id. Animi qui molestiae similique maiores voluptatem. Dolore voluptatem vero sed ab iusto porro hic sit eos. Numquam adipisci tempora natus quam quas quia ipsa. Sit esse vel cum veniam similique sit.
Ratione reiciendis ducimus vel in quis voluptatem et quaerat.
Error adipisci nostrum laborum quae aliquid.
VIP.Lorem.WordReturns a word on random lorem methods.=VIP.Lorem.Word()

Returns:
nemo
dolorem
accusamus
VIP.Lorem.WordsReturns words on random lorem methods.=VIP.Lorem.Words()

Returns:
dolorum consequuntur assumenda
non consequatur beatae
aliquid est perspiciatis
VIP.Lorem.ReviewReturns a random user product review.=VIP.Lorem.Review()

Returns:
My co-worker Atha has one of these. He says it looks narrow.
My chicken loves to play with it.
This product works outstandingly well. It grudgingly improves my baseball by a lot.
VIP.Random.RandomStringFixedLengthReturns a random string of a specified, fixed length. The function is formatted =VIP.Random.RandomStringFixedLength(length, includeNumbers, includeSpecialChars=VIP.Random.RandomStringFixedLength(7,TRUE,TRUE)

Returns:
vXf2P=G
D%r=nNV
Gjs3$d1