Skip to main content
15 events
when toggle format what by license comment
Jun 4, 2021 at 14:43 vote accept Vérace
Jun 2, 2021 at 10:39 answer added Philippos timeline score: 1
Jun 2, 2021 at 9:05 comment added Vérace @Kusalananda - no, you are correct - my edit didn't change what I wanted, but it did expand the scope significantly - so, I'll ask another question tomorrow - and by clear this time! :-)
Jun 2, 2021 at 8:23 comment added Kusalananda @Vérace You can certainly clarify the current question, but the edit seemed to change what it was you asked for.
Jun 2, 2021 at 7:58 comment added Vérace @Kusalananda - OK - my bad... I should have put the full table in first... will ask new question! I've answered a number of questions on another forum and I know that there is nothing more irritating than having the OP "change the goalposts", however I would have thought that it was blindingly obvious that this would apply to multiple lines... a reminder that not everybody is [interested in | consumed by] databases... :-)
Jun 2, 2021 at 7:53 comment added Kusalananda 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.
Jun 2, 2021 at 7:52 history rollback Kusalananda
Rollback to Revision 1
Jun 2, 2021 at 4:02 answer added cas timeline score: 1
Jun 2, 2021 at 3:18 comment added cas 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)?
Jun 1, 2021 at 18:28 history edited Vérace CC BY-SA 4.0
added 1523 characters in body
Jun 1, 2021 at 15:06 answer added DanieleGrassini timeline score: 3
Jun 1, 2021 at 14:50 comment added Chris Davies Yes... I appreciate the generalisation, thanks; I'm trying to check I understand your mapping in the case of the example
Jun 1, 2021 at 14:44 comment added Vérace @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?
Jun 1, 2021 at 14:37 comment added Chris Davies Does your first instance of xy match the 40 from the corresponding original?
Jun 1, 2021 at 14:27 history asked Vérace CC BY-SA 4.0