Search by format

[Natter]

Hi,

Is it possible to search in the text by format ?
For example, there is a date in the text in the form of dd/mm/yyyy.
I need to find this fragment and determine that it is exactly the date (a la Excel - mask search "??/??/????")

[nageswaragunupudi]

Use RegEx
Example:

Code: Select all  Expand view

  cRegExDate := "[0-3][0-9][-|/|.][0-1][0-9][-|/|.][1-2][0-9][0-9][0-9]"
   ? HB_ATX( cRegExDate, "His date of birth is 20/10/1986, What is his age?" )
   // result "20/10/1986"
 

[Natter]

Great! Thanks !

[Natter]

how to include regular expression unicode characters (for example: « » ) ?

[nageswaragunupudi]

Are you programming for East Asian languages?
If you are confined to English and West European languages, all characters other than accented characters are represented by a single byte (and the same byte) both in ANSI and UTF8.
So, normal RegEx expressions should work with UTF8 text also, if you are not programming for Asian languages

[Natter]

That's not how I asked the question.
I am interested in a regular expression for a date of this format «06» April 2023 (months may be different)

[karinha]

https://forums.fivetechsupport.com/viewtopic.php?f=6&t=28002&p=246040&hilit=readline&sid=3318f7707716d9abdc94aeb8583e2195&sid=bf1b0534a0dd4f61eadde738588685b2#p246040

https://forums.fivetechsupport.com/viewtopic.php?f=3&t=36763&p=219288&hilit=readline&sid=3318f7707716d9abdc94aeb8583e2195&sid=bf1b0534a0dd4f61eadde738588685b2#p219288

https://forums.fivetechsupport.com/viewtopic.php?f=3&t=26587&p=147069&hilit=readline&sid=3318f7707716d9abdc94aeb8583e2195&sid=bf1b0534a0dd4f61eadde738588685b2#p147069

https://forums.fivetechsupport.com/viewtopic.php?f=3&t=24719&p=133998&hilit=readline&sid=3318f7707716d9abdc94aeb8583e2195&sid=bf1b0534a0dd4f61eadde738588685b2#p133998

https://forums.fivetechsupport.com/viewtopic.php?f=6&t=20365&p=108243&hilit=readline&sid=3318f7707716d9abdc94aeb8583e2195&sid=bf1b0534a0dd4f61eadde738588685b2#p108243

https://forums.fivetechsupport.com/viewtopic.php?f=6&t=16993&p=88154&hilit=readline&sid=3318f7707716d9abdc94aeb8583e2195&sid=bf1b0534a0dd4f61eadde738588685b2#p88154

Regards, saludos.

[nageswaragunupudi]

Code: Select all  Expand view

local cRegEx := "[«][0-3][0-9][»]"
? hb_atx( cRegEx , "test this «23». working" )
 

Result : "«23»"
Note: These are not Unicode characters.