Generating patterned text data

In the Generate Patterned Text Data dialog box, specify the base sequence and the repetition pattern.

Enter the base sequence

Enter the text values that you want to repeat, separated by spaces. Enclose values that include spaces in quotation marks. For example, enter "New York" "Hong Kong" London.

Specify the repetition pattern

  1. In Number of times to list each value, enter the number of times that you want each value in the sequence to be consecutively repeated.
  2. In Number of times to list the whole sequence, enter the number of times that you want to repeat the entire sequence.

Examples of repetition patterns

Base sequence Number of times to list each value Number of times to list the whole sequence Output
10 20 3 1 10 10 10 20 20 20
1 7 6 1 3 1 7 6 1 7 6 1 7 6
A Z O 2 2 A A Z Z O O A A Z Z O O
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy