RegExp List Generator

by Vitaly, Wednesday, December 21st, 2016

RegExp List Generator 1.16 has been released.

What’s New

1. New option: “Don’t output Columns that start with @”.

This option is useful for generate values that are used in several columns.
For example, if you want to generate the user name as a combination of the first name, last name, or initials, you can do that this way:

Columns:

@FI=[A-Z]
FirstName=%%=@FI%%[a-z]{5,12}
@LI=[A-Z]
LastName=%%=@LI%%[a-z]{5,15}
Username=(%%=@FI%%|%%=FirstName%%)[._-]?(%%=@LI%%|%%=LastName%%)

Example of the Output:

FirstName,LastName,Username
Bpeeahda,Gbkdtl,B_G
Hnnbov,Hocadrtjzyx,HnnbovHocadrtjzyx
Hojbxuinx,Okalcywmpxsczwjn,H-Okalcywmpxsczwjn
Pfrezeezto,Vkkagdqnobo,P.V
Dkncdbdkiatl,Uwcicfbo,DkncdbdkiatlUwcicfbo
Mkqyehiqxgdwp,Hqbbuaf,Mkqyehiqxgdwp-H
Buefvilfxyjyr,Uybtxynfiha,Buefvilfxyjyr-Uybtxynfiha
Amlbvlak,Jgmyurg,AmlbvlakJ
Moxmemuh,Abbmpfwkpg,M_A

2. Generate SQL Insert Statements.

Example of the generated SQL Insert Statements:

INSERT INTO "schema1"."table1" ("FirstName","LastName","Username") VALUES ('Xjbusbgffhgo','Zyzcmng','XZ');
INSERT INTO "schema1"."table1" ("FirstName","LastName","Username") VALUES ('Bcgdhbxsdxgnd','Kvcxgkrkbzg','Bcgdhbxsdxgnd.Kvcxgkrkbzg');
INSERT INTO "schema1"."table1" ("FirstName","LastName","Username") VALUES ('Umklpw','Crpehsl','UCrpehsl');
INSERT INTO "schema1"."table1" ("FirstName","LastName","Username") VALUES ('Subcwhyx','Gxjkfyrcc','Subcwhyx_Gxjkfyrcc');
INSERT INTO "schema1"."table1" ("FirstName","LastName","Username") VALUES ('Symupexprzm','Sossuifnbgieighh','SymupexprzmS');

3. Save, Load or Delete stored Columns

Tags: