3.31 mnewnumber - Generate List of Sequential Numbers

Define the start value of the alphabetic sequence at the S= parameter, set the the interval of alphabet sequence at I= parameter, and define the column name of the sequence at a= parameter. The alphabet sequence uses 26 alphabetic characters in base-26 from A to Z (A,B, $\cdots$ ,Z,AA,AB, $\cdots$ ,AZ,BA,BB, $\cdots$ ,ZZ,AAA,AAB, $\cdots$ ).

Format

mnewnumber a= [I=] [S=] [l=] [o=] [-nfn] [-nfno] [--help] [--version]

Parameters

`a=`	Specify the field name of the list of new serials.
	This parameter is not required when `-nfn,-nfno` option is specified.
`I=`	Interval between the sequence of numbers [default value: 1]
`S=`	Starting value/alphabet(upper case letters) [default value:1]
	Assign either alphabet or numbers as the starting value of the sequence.
	A list of serial numbers is generated when the starting numeric value is specified.
	An alphabet sequence is generated when the starting alphabet is specified (cannot be specified in lowercase).
`l=`	Number of rows to generate [default value:10]

Examples

Example 1: Basic Example

Generate a dataset with 5 sequential numbers starting from 1 incremented by 1. Name the sequence as No..

$ mnewnumber a=No. I=1 S=1 l=5 o=rsl1.csv
#END# kgNewnumber I=1 S=1 a=No. l=5 o=rsl1.csv
$ more rsl1.csv
No.
1
2
3
4
5

Example 2: Change the starting number and interval

Generate a dataset consisting of 5 sequential numbers starting from 10 with an incremental interval of 5. Name the sequence as No..

$ mnewnumber a=No. I=5 S=10 l=5 o=rsl2.csv
#END# kgNewnumber I=5 S=10 a=No. l=5 o=rsl2.csv
$ more rsl2.csv
No.
10
15
20
25
30

Example 3: Generate series of alphabet

Generate a dataset consisting of 5 alphabet sequence starting from A with 1 alphabet in between. Name the sequence as No..

$ mnewnumber a=No. I=1 S=A l=5 o=rsl3.csv
#END# kgNewnumber I=1 S=A a=No. l=5 o=rsl3.csv
$ more rsl3.csv
No.
A
B
C
D
E

Example 4: Generate data without header

Generate a dataset consisting of 11 alphabet sequence starting from B with 3 alphabets in between. Exclude the header from the output.

$ mnewnumber  -nfn  I=3 l=11 S=B o=rsl4.csv
#END# kgNewnumber -nfn I=3 S=B l=11 o=rsl4.csv
$ more rsl4.csv
B
E
H
K
N
Q
T
W
Z
AC
AF

Related Commands

mnewrand : Generate a dataset with random numbers.

mnewstr : Generate fixed character strings.