Function List

September 11, 2018
|By Thomas Pryce

Search Knowledge Base by Keyword

Created OnSeptember 11, 2018
byThomas Pryce
< Back

The data generation 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.

 

General functions

Function NameDescriptionExample
DataGen.FormattedStringReturns a random string, using the format “# = Number, ? = Letter, * = Number or Letter”.=DataGen.FormattedString("# = 3, ? = A, * = 5")

Returns:
2 = 3, C = A, 7 = 5
6 = 3, L = A, 9 = 5
1 = 3, Q = A, 2 = 5
DataGen.Random.RandomFromCSVReturns a random value from a list of specified values.=DataGen.Random.RandomFromCSV("Red,Yellow,Green,Blue")

Returns:
Red
Yellow
Red
DataGen.SetLocaleSets the Locale.=DataGen.SetLocale("sv")

Returns:
Locale is set to sv
DataGen.SetSeedSets the Seed.=DataGen.SetSeed(2)

Returns:
Seed is set to 2

 

Numbers

Functions for generating integers and decimals.

Function NameDescriptionExample
DataGen.Random.RandomDoubleReturns a random double variable less than 1.=DataGen.Random.RandomDouble()

Returns:
0.291310112
0.634659199
0.968867593
DataGen.Random.RandomIntReturns a random integer value within a defined range. The function is formatted =DataGen.SequenceInt(minValue, maxValue).=DataGen.Random.RandomInt(1, 6)

Returns:
6
2
6
DataGen.Random.RandomLongReturns a random big integer value within specified long range. The function is formatted =DataGen.Random.RandomLong(minValue, maxValue).=DataGen.Random.RandomLong(1,50000)

Returns:
229432
33478
8765
DataGen.SequenceIntReturns a random integer from a defined starting point, without duplicate values. The function is formatted =DataGen.SequenceInt(sequence name, starting number). Integers will not duplicate within each given sequence name.=DataGen.SequenceInt(1, 1)

Returns:
1
2
3

 

Addresses

Functions that generate names and postal addresses.

Function NameDescriptionExample
DataGen.Address.BuildingNumber Returns a random building number between 3 and 5 characters for an address.=DataGen.Address.BuildingNumber()

Returns:
076
4583
5567
DataGen.Address.CityPrefixReturns a random city prefix.=DataGen.Address.CityPrefix()

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

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

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

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

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

Returns:

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

Returns:
61.9834
-69.9603
-64.8166
DataGen.Address.LongitudeReturns a random longitude.=DataGen.Address.Longitude()

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

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

Returns:
Orissa
Pondicherry
Jammu and Kashmir

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

Returns:
UT
OK
VA

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

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

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

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

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

Returns:
park
straat
plantsoen

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

Returns:
TN01 2XU
YP23 1FE
UO8 1BQ

When Locale is set to en_GB

 

Product and company

Functions that generate company and product information.

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

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

Returns:
gold
yellow
ivory
DataGen.Commerce.PriceReturns a random product price. The function is formatted =DatGen.Commerce.Price(minimum value, maximum value, number of decimal places, currency symbol). Note: the cell must be formatted to the relevant currency for the symbols to be generated.=DataGen.Commerce.Price(1,4,2,"$")

Returns:
$2.46
$1.78
$2.54

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

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

Returns:
Sleek
Refined
Fantastic
DataGen.Commerce.ProductMaterialReturns a random product material.=DataGen.Commerce.ProductMaterial

Returns:
Metal
Rubber
Cotton
DataGen.Commerce.ProductNameReturns a random, three word product name, combining adjective, material, product type.=DataGen.Commerce.ProductName()

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

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

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

Returns:
Garnier - Perrot
Rosenbaum Group
Reilly – Hermann

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

Returns:
Inc
Ltd
and Sons

 

Database

Functions that generate metadata describing a database.

Function NameDescriptionExample
DataGen.Database.CollationReturns a random database collation.= DataGen.Database.Collation()

Returns:
cp1250_general_ci
ascii_general_ci
utf8_bin
DataGen.Database.ColumnReturns a random database column name.=DataGen.Database.Column()

Returns:
createdAt
token
status
DataGen.Database.EngineReturns a random database storage engine.=DataGen.Database.Engine()

Returns:
CSV
MEMORY
BLACKHOLE
DataGen.Database.TypeReturns a random database column type.=DataGen.Database.Type()

Returns:
bigint
real
serial

 

Dates

Functions that generate dates.

Function NameDescriptionExample
DataGen.Random.RandomDateReturns a random date within a specified range. The function is formatted =DataGen.SequenceInt(“day, month, year”, “day, month, year”). Note: the cell must be formatted to date, with the correct format. =DataGen.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).
DataGen.Date.FutureReturns a random date in the future, with the number of future years specified in the format =DataGen.Date.Future(number of years to go forward) . Note: the cell must be formatted to date, with the correct format. =DataGen.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).
DataGen.Date.MonthReturns a random month.=DataGen.Date.Month()

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

Returns:
Jan
Mar
Nov
DataGen.Date.PastReturns a random date in the past, with the number of past years specified in the format =DataGen.Date.Past(number of years to go back). Note: the cell must be formatted to date, with the correct format. =DataGen.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).
DataGen.Date.RecentReturns a random date within a number of days of the current date, specified in the format =DataGen.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. =DataGen.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).
DataGen.Date.WeekdayReturns a random weekday=DataGen.Date.Weekday()

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

Returns:
Tues
Sun
Mon

 

Finance

Functions that generate account, currency, and transaction information.

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

Returns:
84296305
23065655
16099530
DataGen.Finance.AccountOfSpecifiedLengthReturns a random account number of a length specified in the format =DataGen.Finance.AccountOfSpecifiedLength(number of digits). The number of digits is set to 8 by default. =DataGen.Finance.AccountOfSpecifiedLength(12)

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

Returns:
Savings Account
Personal Loan account
Savings Account
DataGen.Finance.AmountReturns a random amount within a specified range.=DataGen.Finance.Amount()

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

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

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

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

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

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

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

Returns:
£
TT$
?
DataGen.Finance.TransactionTypeReturns a random transaction type: Deposit, Withdrawl, Payment or Invoice.=DataGen.Finance.TransactionType()

Returns:
payment
withdrawal
payment

 

Name

Functions that generate names, prefixes, and job descriptors.

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

Returns:
?
??
??

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

Returns:
Ramon Karlsson
Amy Svensson
Neil Nilsson

When Locale is set to sv
DataGen.Name.JobAreaReturns a job specialism.=DataGen.Name.JobArea()

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

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

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

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

Returns:
Ferrara
Costantin
Bianc

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

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

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

Returns:
I
Sr.
V

 

Phone

Functions that generate phone numbers in specific formats.

Function NameDescriptionExample
DataGen.Phone.PhoneNumberReturns a phone number in specific format.=DataGen.Phone.PhoneNumber()
Returns:

+910245048269
+912292980049
+91289-806-9090

When Locale is set to en_IND
DataGen.Phone.PhoneNumberWithFormatReturns a phone number in a specific format. 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.=DataGen.Phone.PhoneNumberWithFormat("(0)#### ######")

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

When Locale is set to es

 

Internet

Functions that generate information relating to email, IP, URL, and online account details.

Function NameDescriptionExample
DataGen.Internet.AvatarReturns an avatar.=DataGen.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
DataGen.Internet.DomainNameReturns a domain name.=DataGen.Internet.DomainName()

Returns:
samuel.es
clemente.info
patricio.info
DataGen.Internet.DomainSuffixReturns a domain name suffix e.g. .com, .net, .org=DataGen.Internet.DomainSuffix()

Returns:
es
org
info
DataGen.Internet.DomainWordReturns a random word used in domain names.=DataGen.Internet.DomainWord()

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

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

Returns:
firstname_lastname@provider.com
firstname.lastname77@provider.com
firstname_lastname59@provider.com
DataGen.Internet.IpReturns an IP address.=DataGen.Internet.Ip()

Returns:
222.88.182.155
55.114.248.110
134.228.149.234
DataGen.Internet.Ipv6Returns an IP V6 address.=DataGen.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
DataGen.Internet.MacReturns a Mac address.=DataGen.Internet.Mac()

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

Returns:
fBUMRer2Wa
7n3Ku5RcHW
9enZAxmV_r
DataGen.Internet.PasswordWithDetailsReturns a password of a length specified in the format =DataGen.Internet.PassWithDetails(number of characters).=DataGen.Internet.PasswordWithDetails(6)

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

Returns:
http
https
https
DataGen.Internet.UrlReturns a URL.=DataGen.Internet.Url()

Returns:
https://lourdes.com
https://federico.com
http://jacobo.es
DataGen.Internet.UserAgentReturns a UserAgent. Data generated by this function reflects the prevalence of Mozilla over Opera.=DataGen.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)
DataGen.Internet.UserNameReturns a username.=DataGen.Internet.UserName()

Returns:
JoseEmilio_Valle
Daniela_Godoy94
Rosa.Cardona92
DataGen.Internet.WithDetailsReturns a username using variations of a first and last name, specified in the format =DataGen.Internet.WithDetails(“firstname”, “lastname”).=DataGen.Internet.WithDetails(“first”, “last”)

Returns:
first.last22
first.last
first91

 

“Hacker”

Functions that generate basic linguistics units loosely associated with hackers.

Function NameDescriptionExample
DataGen.Hacker.AbbreviationReturns an abbreviation.=DataGen.Hacker.Abbreviation()

Returns:
IB
SAS
CSS
DataGen.Hacker.AdjectiveReturns an adjective.=DataGen.Hacker.Adjective()

Returns:
optical
open-source
optical
DataGen.Hacker.IngVerbReturns an ing-verb.=DataGen.Hacker.IngVerb()

Returns:
parsing
quantifying
indexing
DataGen.Hacker.NounReturns a noun.=DataGen.Hacker.Noun()

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

Returns:
If we index the panel, we can get to the RAM panel through the redundant RAM panel!
compressing the firewall won't do anything, we need to program the neural SAS firewall!
quantifying the hard drive won't do anything, we need to index the mobile GB hard drive!
DataGen.Hacker.VerbReturns a verb.=DataGen.Hacker.Verb()

Returns:
navigate
reboot
input

 

Text

Functions that generate placeholder text.

Function NameDescriptionExample
DataGen.Lorem.LinesReturns lines of lorem ipsum filler text.=DataGen.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.
DataGen.Lorem.ParagraphReturns one paragraph of lorem ipsum filler text.=DataGen.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.
DataGen.Lorem.ParagraphsReturns a number of paragraphs of lorem ipsum filler text., specified in the format =DataGen.Lorem.Paragraphs(number of paragraphs)=DataGen.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."
DataGen.Lorem.SentenceReturns a sentence of lorem ipsum filler text.=DataGen.Lorem.Sentence()

Returns:
Odio dolorem unde alias officiis illo doloribus quia aut cupiditate.
Accusantium eligendi adipisci distinctio.
Ducimus corrupti cum.
DataGen.Lorem.SentencesReturns a number of sentences of lorem ipsum filler text., specified in the format =DataGen.Lorem.Paragraphs(number of sentences)=DataGen.Lorem.Sentences(2)

Returns:
Autem enim debitis non quisquam deleniti. Labore quibusdam et. Quis aut facere.
Omnis exercitationem modi architecto excepturi assumenda reprehenderit sunt et nihil. Illum excepturi vel sed vero illum quos sed culpa. Nostrum sit minima reprehenderit.
Facere voluptas ab. Rerum molestiae itaque quaerat odit quod modi. Dolorem dolorum voluptatibus eius magnam qui.
DataGen.Lorem.SlugReturns a lorem ipsum slug of length specified in the format =Datagen.Lorem.Slug(numer of words)=DatGen.Lorem.Slug(4)

Returns:
iusto-et-autem-tempore
id-et-aut-enim
nostrum-repudiandae-est-officia
DataGen.Lorem.TextReturns text using one of the other Lorem functions.=DataGen.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.
DataGen.Lorem.WordReturns a ipsum word=DataGen.Lorem.Word()

Returns:
nemo
dolorem
accusamus
DataGen.Lorem.WordsReturns a number of ipsum lorem words=DataGen.Lorem.Words()

Returns:
dolorum consequuntur assumenda
non consequatur beatae
aliquid est perspiciatis
DataGen.Lorem.ReviewReturns a user review in English.=DataGen.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.

 

String Extensions

Functions that process a string.

Function NameDescriptionExample
DataGen.General.Random.ParseReturns a string value after resolving a set of functions specified in the format =DataGen.Random.Parse(“{{function1}} {{function2}} {{functionN}}”).=DataGen.Random.Parse("{{name.prefix}} {{name.lastname}} {{name.suffix}}")

Returns:
Dr. Herman MD
Mrs. Koch DVM
Mrs. Bogisich III
DataGen.General.Random.SpinReturns a random string value after ‘spinning’ text. Spinning generates variations of variables specified in the format =DataGen.Random.Spin(“{{variable 1|variable2|variable}}”). Spin functions can be strung together. Values outside of squiggly brackets will be reproduced literally. =DataGen.Random.Spin("{{Red|Yellow} is {my|your} {favourite|least favourite} colour }")

Returns
Yellow is my least favourite colour
Red is my favourite colour
Red is your least favourite colour
DataGen.Random.RandomStringFixedLengthReturns a random string of fixed length with or without numbers and special characters. The function is formatted =DataGen.Random.RandomStringFixedLength(length, includeNumbers, includeSpecialChars)=DataGen.Random.RandomStringFixedLength(7,TRUE,TRUE)

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