Expression May Generate Data Too Long

Phil_H

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

Kurt_M

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? 

Phil_H

Thanks fore the response. Unfortunately we are limited with the data types as we are trying to generate data for a legacy DB that we do not control. I've changed my Regex now and all good