Regex Hell help

Thu, 30 Apr 2009 21:44:49 GMT

For some odd reason, it was decided to keep the dates found in electronic contracts embedded in the text of the digital contract, found in a text field. Of course, if the contract is in a different language, you gotta code for that as well. 🙂 Better yet, said date follows this format:

<td width="20%">
Application Date: 
Funding Date: 
Due Date: 
</td>
<td>
March 17, 2005 
March 21, 2005 
April 11, 2005 
</td>

I need to parse out the correct Due Date (in this instance, it's 4/11/2005) somehow.

Tried regular expressions and, as usual, failed to get that engine to do what I want...

select substring(digital_contract_text from '%Due Date:#"(\f|\n|\r| |\t|\v)*\<br\/\>(\f|\n|\r| |\t|\v)*\<\/td\>(\f|\n|\r| |\t|\v)*\<td\>(\f|\n|\r| |\t|\v)*([a-z]| |[A-Z]|,|[0-9])+\<br\/\>(\f|\n|\r| |\t|\v)*([a-z]| |[A-Z]|,|[0-9])+\<br\/\>(\f|\n|\r| |\t|\v)*([a-z]| |[A-Z]|,|[0-9])+#"\<br\/\>%' for '#')
from table_foo
where id = 370

Hilariously, if one moves the initial #" anywhere else than where it is already, the query blows up.

How do I go about parsing that DueDate out of that HTML mess?

Regex Hell help

Oleg_Troyansky — Thu, 30 Apr 2009 23:09:48 GMT

Try using function subfield. See attached sample.

Oleg

Regex Hell help

Fri, 01 May 2009 01:32:29 GMT

Sweet. Wish SQL had this...

Regex Hell help

rwunderlich — Fri, 01 May 2009 02:04:49 GMT

TextBetween() might also be a good approach.

trim(TextBetween(vOriginal, ' ', '<', 5));

-Rob

topic Regex Hell help in QlikView

Regex Hell help

Regex Hell help

Regex Hell help

Regex Hell help