By using RegExp List Generator you can generate random test data in CSV format.
The generated random data is based on the defined regular expressions.
You can define Macro Tags for the common regular expressions.
Free for private, non-commercial use.
If you like RegExp List Generator you may like to donate a small amount to help me keep developing and updating.
Bitcoin address: 1Zq1tVv6VAzJi24H1gMtKiBb2JJPpq9Eb Copy
Columns (ColumnName=RegExp):
RowNum=%%ROW:1000%%
Email=[a-z][a-z]{5,8}[0-9]{4}@test[1-9]\.com
FirstName=[A-Z][a-z]{5,12}
LastName=[A-Z][a-z]{5,15}
IP=%IPLIST1%|%IP4%
CreateTime=%RDATETIME%
Website=http://([a-z][a-z0-9]{5}\.)?[a-z][a-z0-9]{7,9}\.com/
ModifyDate=%%FORMATDT:dd\.mm\.yyyy,2016-11-10,2016-11-20%%
EmailCopy=%%=Email%%
RegExp Macro Tags (TagName=RegExp):
%H24%=[01][0-9]|2[0-3]
%MM%=[0-5][0-9]
%SS%=[0-5][0-9]
%RTIME%=%H24%:%MM%:%SS%
%MD31%=(0[13578]|1[02])-([12][0-9]|3[01])
%MD30%=(0[469]|11)-([12][0-9]|30)
%MD28%=02-(1[0-9]|2[0-8])
%YYYY%=19[7-9][0-9]|200[0-9]|201[0-6]
%RDATE%=%YYYY%-(%MD31%|%MD30%|%MD28%)
%RDATETIME%=%RDATE% %RTIME%
%IP4%=(%OCT%\.){3}%OCT%
%OCT%=([0-9])|(1[0-9][0-9]?)|([2-9][0-9])|(2[0-4][0-9])|(25[0-5])
Rotate Lines (TagName=FilePath):
%IPLIST1%=C:\temp\lists\iplist1.txt
Predefined Macro Tags:
%%=Name%%
%%ROW%%
%%ROW:First,Increment%%
%%DATE%%
%%DATE:Start,End%%
%%TIME%%
%%TIME:Start,End%%
%%DATETIME%%
%%DATETIME:Start,End%%
%%FORMATDT:yyyy-mm-dd hh:nn:ss,Start,End%%
Result List (Text):
RowNum,Email,FirstName,LastName,IP,CreateTime,Website,ModifyDate,EmailCopy
1000,ujgauib3074@test2.com,Delizvhcez,Authubgghfyjgvd,217.255.4.169,2000-12-18 19:45:36,http://gyhoap.ngqyje0st.com/,12.11.2016,ujgauib3074@test2.com
1001,vddjzke0907@test4.com,Vqhncvn,Wkchlccljcukqy,11.245.19.1,2012-05-15 22:49:01,http://zib8bl.ylyf8m2l.com/,10.11.2016,vddjzke0907@test4.com
1002,abtaedkq8398@test8.com,Qwxrrhuxwr,Tdbedu,227.9.252.253,2011-02-19 15:29:56,http://wcf143.ko67kkan.com/,11.11.2016,abtaedkq8398@test8.com
1003,kqzthnmwy5595@test3.com,Aqxvkrtrzgc,Vhzpuuitjnkuebr,153.1.250.72,2012-02-21 23:29:00,http://zd19rjni.com/,10.11.2016,kqzthnmwy5595@test3.com
1004,vytccku7077@test7.com,Vadxbuirbugj,Pssqszibg,253.68.3.255,1981-04-20 21:22:45,http://evt59e.ulf5i8ask.com/,11.11.2016,vytccku7077@test7.com
1005,wqtgen9253@test7.com,Kjfqarnfhf,Niybvpcvrgvzw,139.202.184.253,2008-08-31 19:32:10,http://r1io3p.qy2u8jpz6.com/,13.11.2016,wqtgen9253@test7.com
1006,hdfjtbbu6961@test8.com,Tdvkopjlsa,Dnxzricmspc,190.5.0.22,2016-05-30 21:47:31,http://r1yv9e.vcs6kom6v.com/,11.11.2016,hdfjtbbu6961@test8.com
1007,nipseu8145@test1.com,Qwgterke,Btqirrizsjw,16.245.68.5,1973-09-30 10:46:06,http://dgpxxt.k8sh32r7.com/,11.11.2016,nipseu8145@test1.com
1008,aszzqbhxn9487@test3.com,Jekyqpe,Ujjwkuqspe,62.254.6.72,2009-03-30 03:01:33,http://buoevq7d.com/,11.11.2016,aszzqbhxn9487@test3.com
1009,purjqw9294@test9.com,Llapfsp,Fwndrhib,73.210.254.29,2014-11-19 20:52:19,http://jk310b5p2.com/,15.11.2016,purjqw9294@test9.com