What are the challenges you face when working across database platforms? Take the survey
Options

Expression May Generate Data Too Long

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
Tagged:

Best Answer

Answers

  • Options
    Phil_HPhil_H Posts: 2 New member
    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
Sign In or Register to comment.