String Generators - Compare, Evaluate, Combine, or Alter String Values Print

Example 1 - Concatenate 'Hello' and first name generated by another Attribute or Generator along with a comma.

The result would be:

• Hello Jim,
• Hello Sarah,
• Hello Tony,

Example data set = 1, 2, 3, 4, 5
Reset Value = 5
Delimiter = | (pipe)

Output values:

• 1
• 1|2
• 1|2|3
• 1|2|3|4
• 1|2|3|4|5
• starts over at 1 and repeats the same as above
  
   

Below is an example where the parent changes in the following sequence: 1/1, 1/4, 6/2, and 8/1. 

The child starts at 2 and continually increases by 1.

• 1 - 1|2
• 2 - 1|2|3
• 2 - 1|2|4
• 2 - 1|2|5
• 2 - 1|2|6
• 6 - 1|2|6|7
• 6 - 1|2|6|8
• 8 - 1|2|6|8|9

Examples:

• country = USA
• currency = USD
• tax rate = 0.07
• branch id = 2005
• active = true
• status = pending
• null
• test
• exclude
  
   

Example: Reference the id Attribute for a test Domain.

• testToEncrypt = #{Test.id}
• algorithm = SHA-256
• upperCase = true
  
   

Output for id '1' = 6B86B273FF34FCE19D6B804EFF5A3F574
7ADA4EAA22F1D49C01E52DDB7875B4B

Examples:

• #{BLANK}
• #{EMPTY)
• null

Checks a list of values for a match to a compared value. The list of values may be a set of Constants, Attribute references, or a combination of both. The match types are:

• contains - anywhere within the string
• startWith - at the beginning of the string
• endsWith - at the end of the string

The match conditions are:

• and - all must be true
• or - only one must be true

If compare value = 'table'
and matchType = 'contains'
and matchCase = 'true'
and the list of values =

• Table
• Playable
• Stable

then matchCondition:

• and returns False
• or returns True

An Attribute is generating a string that contains 1 letter as the starting character and then random numbers.

• H23864
• J37961
• C09143
• N38410

If the string starts with 'C' it should return 'true', otherwise 'false'

Generated data values for four strings above:

• false, false, true, false

Examples with 10 letters:

• upper case -IASPRZWFAG
• lower case - pauxbzwyin
• mixed - iMYnDIjGdg
  
   

Example 1

• Range = 1 to 5
• Prefix = test
• Output = test1, test2, test3, test4, test5

Example 2

• Range = 1 to 5
• Suffix = test
• Output = 1test, 2test, 3test, 4test, 5test
  
   

Produces a result by evaluating a regular expression using a constant or referenced value. Examples of regular expressions include:

• [a-z]
• 1
• a
• $ (two or more)

If 'true' returned, then passCase provided; otherwize, failCase provided. These can be a constant or referenced value.

 

Example 1 - For every occurrence of 'user' in a referenced Attribute value, replace it with 'name'.

Example 2 - Remove extra spaces in generated values. Reference the Attribute and use \s in the fromText parameter.

• (800) 899-1111 becomes (800)899-1111
• ap ple becomes apple
  
   

Example Strings

• I like apples
• I would rather have oranges
• What do you prefer

Generated value with index set to '1'

• like
• would
• do

Generated value with index set to '3' and ignoreBound 'true'

• empty string (no value to return)
• have
• prefer
  
   

Check what type of content the string contains. You can enter a constant value or reference another Attribute.

If the result of the evaluation is true, then the value of castTrue will be returned for the record. Otherwise, the value of caseFalse will be returned. Both parameters can have a constant value or reference another Attribute.

You can perform the following checks:

• isAlphaNumeric
• isAllWhiteSpaces
• isBigDecimal
• isBigInteger
• isDouble
• isEmpty
• isFloat
• isInteger
• isLong
• isNumber

Example Strings:

• I like apples
• null
• 1234567

If I check for isNumeric with caseTrue = 'true' and caseFalse = 'false', the returned values would be:

• false
• false
• true

Alternatively, caseTrue could reference another Attribute when 'true' rather than be a constant value.

Here are a few examples:

• Return the last four digits of a phone number.
   
• Return the last four digits of an SSN.
• Remove a prefix from a value (e.g., ID-67843, TRK-78234).
• Use a portion of a product name, code, or label.
• Return the date portion from a timestamp.
• Isolate a department code from an Employee ID.