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.
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