Comments
1 comment
-
We don't really have much to help here unfortunately. https://documentation.red-gate.com/sdg/using-generators/generic-generators#Genericgenerators-Regexpgenerator has a few basic pointers but doesn't sound like it's going to help.
(?ifthen|else) though does exist in regex. Try https://www.regular-expressions.info/conditional.html as a resource.
Add comment
Please sign in to leave a comment.
Suppose I have two columns and I want column 2 to be based on the random value from column 1. For example, column 1 is Yes|No. I'd like column 2 to be 1 when column 1 = Yes and 0 when column 1 = No. Is this possible? I am new to regex expressions and tried to search online for examples, but what I found doesn't seem to work in SQL Data Generator.
Thanks for your help and suggestions!