Skip to main content
Unix & Linux

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

8
  • Does your first instance of xy match the 40 from the corresponding original? Commented Jun 1, 2021 at 14:37
  • @roaima - not necessarily - xy could be any integer from 5 - 5000 (arbitrary)... hence [0-9]+ - there has to be at least one digit present, so not [0-9]*. That is: (xy) corresponds to whatever integers would be in those brackets! fieldname VARCHAR(543) => xy = 543 and is the back-reference in the regex! I hope this is clear? Commented Jun 1, 2021 at 14:44
  • Yes... I appreciate the generalisation, thanks; I'm trying to check I understand your mapping in the case of the example Commented Jun 1, 2021 at 14:50
  • 1. You say "it doesn't make sense to take the LENGTH of a NULL". Both region and postalcode are VARCHAR(n) NULL, yet you want them to have a length check in the desired output. Which is correct? 2. Where does the test_field come from? and the extra blank lines (before birthdate, address, phone)? Commented Jun 2, 2021 at 3:18
  • 1
    I have rolled back your edit as it substantially changed the question and since you have already received an answer to your original question. If you have another related issue, then please open a new question rather than re-writing your original question. Commented Jun 2, 2021 at 7:53