Timeline for Regular expression - SQL manipulation
Current License: CC BY-SA 4.0
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 |