Options
Expression May Generate Data Too Long
Phil_H
Posts: 2 New member
Hi,
Trying to populate a data item with Last Name & Initial (($"NamesLast.txt") ([ABCDHNPRST]|[A-EGHN-T]|[A-Z]){1,2}) but my data type is limited to length 10 so I'm getting:
"RegEx Generator : Expression too long. Expression may generate strings too wide for column".
Can I wrap a SUBSTRING(1,10) around the above?
Thanks in advance
Trying to populate a data item with Last Name & Initial (($"NamesLast.txt") ([ABCDHNPRST]|[A-EGHN-T]|[A-Z]){1,2}) but my data type is limited to length 10 so I'm getting:
"RegEx Generator : Expression too long. Expression may generate strings too wide for column".
Can I wrap a SUBSTRING(1,10) around the above?
Thanks in advance
Tagged:
Best Answer
-
OptionsKurt_M
Posts: 178 Silver 1
Hi @Phil_H
I'm afraid that the regex generator does not have the ability to use something like the SUBSTRING function. For more complicated data inserts, I would suggest looking into the python script, or even the SQL statement.
https://documentation.red-gate.com/sdg/using-generators/generic-generators
Alternatively, is there a way you can increase the length above 10?Kind regards,
Kurt McCormick
Product Support Engineer, RedgateNeed help? Take a look at our Help Center
Answers