[wtr-general] Re: Unable to find the value blah... within a listbox. Value is retrieved from excel cell

2008-12-02 Thread Darin Duphorn

I've tried both copying it from and entering manually and I'm always getting 'à'

I've also tried this in the ruby code and it didn't work .gsub('à'.'...')

Thanks though.

I've asked the developers to remove the ... from the word.  






-Original Message-
From: watir-general@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of 
Alex Collins
Sent: Tuesday, December 02, 2008 1:40 AM
To: watir-general@googlegroups.com
Cc: watir-general@googlegroups.com
Subject: [wtr-general] Re: Unable to find the value blah... within a listbox. 
Value is retrieved from excel cell


This is because in Excel you likely have the ellipsis character (...)  
as a single character not three separate period chracters (.).

Ruby (and therefor Watir) doesn't support character sets / unicode as  
one might expect. Therefore you receive the á character instead.

Try pasting the value into Excel from a plain text editor - notepad  
for example.

On 1 Dec 2008, at 22:29, Darin Duphorn [EMAIL PROTECTED]  
wrote:


 The value in the listbox is displayed as Filter by Coach...

 selected=selected
 Filter by Coach.../option

 The problem seems to be when I read the value from a excel cell it  
 contains á.



 -Original Message-
 From: watir-general@googlegroups.com [mailto:watir-general@googlegroups.com 
 ] On Behalf Of Chuck vdL
 Sent: Monday, December 01, 2008 4:27 PM
 To: Watir General
 Subject: [wtr-general] Re: Unable to find the value blah... within  
 a listbox. Value is retrieved from excel cell


 Can you show us the HTML that defines the listbox and its items?

 On Dec 1, 2:24 pm, Darin Duphorn [EMAIL PROTECTED]
 wrote:
 The actuall value is Filter by Coach...

 The ... That follow the work coach are displaying as á.

 I believe in excel that ... Means á

 Not sure though.



 -Original Message-
 From: watir-general@googlegroups.com
 [mailto:[EMAIL PROTECTED] On Behalf Of Chuck vdL
 Sent: Monday, December 01, 2008 4:18 PM
 To: Watir General
 Subject: [wtr-general] Re: Unable to find the value blah...  
 within a
 listbox. Value is retrieved from excel cell

 Is 'Blah the actual value defined in the HTML for that listbox  
 item, or is perhaps the browser UI visually truncating something  
 longer down to what will fit in available space  for the way the  
 listbox is defined?

 On Dec 1, 1:11 pm, Moochie [EMAIL PROTECTED] wrote:
 For some reason when I attempt to find a value in a listbox that
 contains three dots it doesn't find the value.

 Has anyone else seen this?

 Thanks,

 Darin- Hide quoted text -

 - Show quoted text -



 




--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---



[wtr-general] Re: Unable to find the value blah... within a listbox. Value is retrieved from excel cell

2008-12-02 Thread Darin Duphorn

I've figured it out.

There is a setting within excel that converts ... to ellipses. 

To remove this setting goto Tool- AutoCorrect Options... and removed the ... 
to ... conversion.

Darin



-Original Message-
From: watir-general@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of 
Darin Duphorn
Sent: Tuesday, December 02, 2008 8:28 AM
To: watir-general@googlegroups.com
Subject: [wtr-general] Re: Unable to find the value blah... within a listbox. 
Value is retrieved from excel cell


I've tried both copying it from and entering manually and I'm always getting 'à'

I've also tried this in the ruby code and it didn't work .gsub('à'.'...')

Thanks though.

I've asked the developers to remove the ... from the word.  






-Original Message-
From: watir-general@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of 
Alex Collins
Sent: Tuesday, December 02, 2008 1:40 AM
To: watir-general@googlegroups.com
Cc: watir-general@googlegroups.com
Subject: [wtr-general] Re: Unable to find the value blah... within a listbox. 
Value is retrieved from excel cell


This is because in Excel you likely have the ellipsis character (...)  
as a single character not three separate period chracters (.).

Ruby (and therefor Watir) doesn't support character sets / unicode as  
one might expect. Therefore you receive the á character instead.

Try pasting the value into Excel from a plain text editor - notepad  
for example.

On 1 Dec 2008, at 22:29, Darin Duphorn [EMAIL PROTECTED]  
wrote:


 The value in the listbox is displayed as Filter by Coach...

 selected=selected
 Filter by Coach.../option

 The problem seems to be when I read the value from a excel cell it  
 contains á.



 -Original Message-
 From: watir-general@googlegroups.com [mailto:watir-general@googlegroups.com 
 ] On Behalf Of Chuck vdL
 Sent: Monday, December 01, 2008 4:27 PM
 To: Watir General
 Subject: [wtr-general] Re: Unable to find the value blah... within  
 a listbox. Value is retrieved from excel cell


 Can you show us the HTML that defines the listbox and its items?

 On Dec 1, 2:24 pm, Darin Duphorn [EMAIL PROTECTED]
 wrote:
 The actuall value is Filter by Coach...

 The ... That follow the work coach are displaying as á.

 I believe in excel that ... Means á

 Not sure though.



 -Original Message-
 From: watir-general@googlegroups.com
 [mailto:[EMAIL PROTECTED] On Behalf Of Chuck vdL
 Sent: Monday, December 01, 2008 4:18 PM
 To: Watir General
 Subject: [wtr-general] Re: Unable to find the value blah...  
 within a
 listbox. Value is retrieved from excel cell

 Is 'Blah the actual value defined in the HTML for that listbox  
 item, or is perhaps the browser UI visually truncating something  
 longer down to what will fit in available space  for the way the  
 listbox is defined?

 On Dec 1, 1:11 pm, Moochie [EMAIL PROTECTED] wrote:
 For some reason when I attempt to find a value in a listbox that
 contains three dots it doesn't find the value.

 Has anyone else seen this?

 Thanks,

 Darin- Hide quoted text -

 - Show quoted text -



 







--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---



[wtr-general] Re: Unable to find the value blah... within a listbox. Value is retrieved from excel cell

2008-12-01 Thread Chuck vdL

Is 'Blah the actual value defined in the HTML for that listbox
item, or is perhaps the browser UI visually truncating something
longer down to what will fit in available space  for the way the
listbox is defined?

On Dec 1, 1:11 pm, Moochie [EMAIL PROTECTED] wrote:
 For some reason when I attempt to find a value in a listbox that
 contains three dots it doesn't find the value.

 Has anyone else seen this?

 Thanks,

 Darin
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---



[wtr-general] Re: Unable to find the value blah... within a listbox. Value is retrieved from excel cell

2008-12-01 Thread Darin Duphorn

The actuall value is Filter by Coach...

The ... That follow the work coach are displaying as á.

I believe in excel that ... Means á

Not sure though.



-Original Message-
From: watir-general@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of 
Chuck vdL
Sent: Monday, December 01, 2008 4:18 PM
To: Watir General
Subject: [wtr-general] Re: Unable to find the value blah... within a listbox. 
Value is retrieved from excel cell


Is 'Blah the actual value defined in the HTML for that listbox item, or is 
perhaps the browser UI visually truncating something longer down to what will 
fit in available space  for the way the listbox is defined?

On Dec 1, 1:11 pm, Moochie [EMAIL PROTECTED] wrote:
 For some reason when I attempt to find a value in a listbox that 
 contains three dots it doesn't find the value.

 Has anyone else seen this?

 Thanks,

 Darin



--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---



[wtr-general] Re: Unable to find the value blah... within a listbox. Value is retrieved from excel cell

2008-12-01 Thread Darin Duphorn

The value in the listbox is displayed as Filter by Coach...

 selected=selected
Filter by Coach.../option

The problem seems to be when I read the value from a excel cell it contains á.



-Original Message-
From: watir-general@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of 
Chuck vdL
Sent: Monday, December 01, 2008 4:27 PM
To: Watir General
Subject: [wtr-general] Re: Unable to find the value blah... within a listbox. 
Value is retrieved from excel cell


Can you show us the HTML that defines the listbox and its items?

On Dec 1, 2:24 pm, Darin Duphorn [EMAIL PROTECTED]
wrote:
 The actuall value is Filter by Coach...

 The ... That follow the work coach are displaying as á.

 I believe in excel that ... Means á

 Not sure though.



 -Original Message-
 From: watir-general@googlegroups.com 
 [mailto:[EMAIL PROTECTED] On Behalf Of Chuck vdL
 Sent: Monday, December 01, 2008 4:18 PM
 To: Watir General
 Subject: [wtr-general] Re: Unable to find the value blah... within a 
 listbox. Value is retrieved from excel cell

 Is 'Blah the actual value defined in the HTML for that listbox item, or 
 is perhaps the browser UI visually truncating something longer down to what 
 will fit in available space  for the way the listbox is defined?

 On Dec 1, 1:11 pm, Moochie [EMAIL PROTECTED] wrote:
  For some reason when I attempt to find a value in a listbox that 
  contains three dots it doesn't find the value.

  Has anyone else seen this?

  Thanks,

  Darin- Hide quoted text -

 - Show quoted text -



--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---



[wtr-general] Re: Unable to find the value blah... within a listbox. Value is retrieved from excel cell

2008-12-01 Thread Alex Collins

This is because in Excel you likely have the ellipsis character (...)  
as a single character not three separate period chracters (.).

Ruby (and therefor Watir) doesn't support character sets / unicode as  
one might expect. Therefore you receive the á character instead.

Try pasting the value into Excel from a plain text editor - notepad  
for example.

On 1 Dec 2008, at 22:29, Darin Duphorn [EMAIL PROTECTED]  
wrote:


 The value in the listbox is displayed as Filter by Coach...

 selected=selected
 Filter by Coach.../option

 The problem seems to be when I read the value from a excel cell it  
 contains á.



 -Original Message-
 From: watir-general@googlegroups.com [mailto:watir-general@googlegroups.com 
 ] On Behalf Of Chuck vdL
 Sent: Monday, December 01, 2008 4:27 PM
 To: Watir General
 Subject: [wtr-general] Re: Unable to find the value blah... within  
 a listbox. Value is retrieved from excel cell


 Can you show us the HTML that defines the listbox and its items?

 On Dec 1, 2:24 pm, Darin Duphorn [EMAIL PROTECTED]
 wrote:
 The actuall value is Filter by Coach...

 The ... That follow the work coach are displaying as á.

 I believe in excel that ... Means á

 Not sure though.



 -Original Message-
 From: watir-general@googlegroups.com
 [mailto:[EMAIL PROTECTED] On Behalf Of Chuck vdL
 Sent: Monday, December 01, 2008 4:18 PM
 To: Watir General
 Subject: [wtr-general] Re: Unable to find the value blah...  
 within a
 listbox. Value is retrieved from excel cell

 Is 'Blah the actual value defined in the HTML for that listbox  
 item, or is perhaps the browser UI visually truncating something  
 longer down to what will fit in available space  for the way the  
 listbox is defined?

 On Dec 1, 1:11 pm, Moochie [EMAIL PROTECTED] wrote:
 For some reason when I attempt to find a value in a listbox that
 contains three dots it doesn't find the value.

 Has anyone else seen this?

 Thanks,

 Darin- Hide quoted text -

 - Show quoted text -



 

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---