Search for pattern

HCL Domino Domino Forum
1

I am trying to search all our databases and find any instances where a date has been stored in a text field

I am trying to search for the pattern ??/??/???

I am searching a database where there are thousand of such documents, but I am not getting any results returned

Can anyone tell me what I am doing wrong or suggest a better way

TIA,

Mark.

2

Subject: Search for pattern

how are you searching? script, using built in search, from a view, domain search?

3

Subject: RE: Search for pattern

Set dcScan=dbTarget.FTSearch({??/??/???}, 0)

or

Set dcScan=dbTarget.Search({??/??/???}, dtCutoff,0)

Neither of these work

4

Subject: RE: Search for pattern

been playing around with this and it does not look like ? works for numbers, even though they are in a text field. ? doesn’t even work in a normal search bar query for finding numbers in a text field, only letters.

5

Subject: RE: Search for pattern

Thanks Paul thats what I was getting too.

I’ve given up with this and I’m using Teamstudio Analyser to serach for where a date could have been stored as text eg. look for @TextToTime where it is being converted back into a time variable