[wtr-general] Re: Unable to find the value "blah..." within a listbox. Value is retrieved from excel cell
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: 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... > > 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
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: 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... > > 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
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... > > 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
The value in the listbox is displayed as "Filter by Coach..." selected="selected" >Filter by Coach... 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
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
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
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 -~--~~~~--~~--~--~---