Regular Expressions Case Statements

cvillegascvillegas Posts: 5
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.

Comments

  • 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
  • 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!
  • 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
Sign In or Register to comment.