Page 1 of 1

Ranorex Path

Posted: Tue Oct 09, 2012 4:48 pm
by regex
I am opening an Excel workbook. Each time that workbook changes based on the number of attempts to open.

In order to cope with the name change, I located the needed items using this query:

Code: Select all

workbook[@name>='Prelim']/table/row[@index='10']/cell[@address='E10']
The 'Prelim' name changes. Normally the Spy captures this name for the workbook:

Code: Select all

workbook[@name='PrelimByMonthReport 2 .xls']/table/row[@index='10']/cell[@address='L10']
However I am having trouble finding the required cells using the first >= query. Each time the workbook does open with the title Prelim. Do you have any suggestions on a modified query or something more accurate than >='Prelim'. Thank you in advance.

I also tried making a folder in the repository, setting the base, and adding any child elements. The base is this:

Code: Select all

/workbook[@name~'Prelim[A-Z]']
I need this to accept any workbook OR any workbook starting with that prefix and allowing any uppercase/lowercase characters following the Prelim.

Re: Ranorex Path

Posted: Wed Oct 10, 2012 10:26 am
by Support Team
Hi,

Did you already try the following regular expression?

Code: Select all

/workbook[@name~'(?i:Prelim)']
Regards,
Markus
Ranorex Support Team