Regular Expressions Case Statements

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

Regular Expressions Case Statements

Postby cvillegas » Thu Apr 05, 2012 5:08 pm

Is it possible in the prebuilt generator to utilize case assignment statements in order to affect the case of a set of strings... example: I pull information from another column in the table and I would like for all of that data to be lowercase instead of uppercase.
cvillegas
 
Posts: 4
Joined: Wed Apr 04, 2012 6:50 pm

Postby peter.peart » Mon Apr 09, 2012 1:46 pm

Thanks for your post. No, there isn't unfortunately any way for you to manipulate the data that you're pulling from an existing data source I'm afraid.

I can add this as a feature request for you if you wish?

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

That would be great!

Postby cvillegas » Mon Apr 09, 2012 3:04 pm

Thanks Peter!

Btw just wanted to thank you guys for the SQL Masking utility it's working great for our text DB's as a workaround for excluding columns for data generation!
cvillegas
 
Posts: 4
Joined: Wed Apr 04, 2012 6:50 pm

Postby peter.peart » Thu Apr 12, 2012 8:18 pm

Thanks for your reply, I'm glad you're liking it!
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 0 guests