extracting text

[Dan]

I have a HTML table which I would like to extract text inside a <TD>. For an
example
<TD class=12>Some text</TD>

I can write a code that detects the beginning of TD...
print line ~= "<TD class12>"

But how do I make it stop at </TD>. In the code above, I just want to print
"Some text"

thanks

[Dan]

thank you
"Tim Hunter" <Tim.Hunter@sas.com> wrote in message
news:snstgv4pbjgohvs40b5nv5gn9hcdpl3s9c@4ax.com...

> Here's one answer to your question. Watch out, almost any change to
> the input will break it.
>
> irb(main):012:0> s = "<TD class=12>Some text</TD>"
> "<TD class=12>Some text</TD>"
> irb(main):013:0> m = %r{<TD [^>]+>([^<]+)</TD>}.match(s)
> #<MatchData:0x276f978>
> irb(main):014:0> p m[1]
> "Some text"
> nil
> irb(main):015:0>
>
> On Fri, 11 Jul 2003 07:46:44 -0400, "Dan" <falseflyboy@yahoo.comNONO>
> wrote:
>

> >I have a HTML table which I would like to extract text inside a <TD>. For

an

> >example
> ><TD class=12>Some text</TD>
> >
> >I can write a code that detects the beginning of TD...
> >print line ~= "<TD class12>"
> >
> >But how do I make it stop at </TD>. In the code above, I just want to

print

> >"Some text"
> >
> >thanks
> >

>

[Berger, Daniel]

> -----Original Message-----
> From: Tim Hunter [mailto:Tim.Hunter@sas.com]
> Sent: Friday, July 11, 2003 12:36 PM
> To: [email]ruby-talk@ruby-lang.org[/email]
> Subject: Re: extracting text
>
>
> Here's one answer to your question. Watch out, almost any
> change to the input will break it.
>
> irb(main):012:0> s = "<TD class=12>Some text</TD>"
> "<TD class=12>Some text</TD>"
> irb(main):013:0> m = %r{<TD [^>]+>([^<]+)</TD>}.match(s)
> #<MatchData:0x276f978> irb(main):014:0> p m[1] "Some text"
> nil irb(main):015:0>
>
> On Fri, 11 Jul 2003 07:46:44 -0400, "Dan" <falseflyboy@yahoo.comNONO>
> wrote:
>

> >I have a HTML table which I would like to extract text

> inside a <TD>.

> >For an example <TD class=12>Some text</TD>
> >
> >I can write a code that detects the beginning of TD...
> >print line ~= "<TD class12>"
> >
> >But how do I make it stop at </TD>. In the code above, I

> just want to

> >print "Some text"
> >
> >thanks
> >

I suspect you'll want to use a parser, instead of regular expressions, to
parse HTML. There's an html-parser module on the RAA, though I haven't used
it myself.

Regards,

Dan

[Peter Pan]

Hi,

I have a text field with values such as:

12345/6
12345/85
12345/127

There is always 5 characters before the /.

I would like to get all the characters on the right hand side of the /,
whether it is 1, 2, 3 characters etc. I've been playing with the position
function but can't get it right - anyone know how this can be done?

Many thanks in advance

[John Weinshel]

You can figure out which characters come after your delimiter (the slash) by
subtracting 6 (5 plus the slash itself) from the total number of characters
in the string:

Length(Your_Field)-6

....and you know they will always be on the right. Now you know how many
characters you want, and you can use the Right() function to retrieve their
value.

--
John Weinshel
Datagrace
Vashon Island, WA
(206) 463-1634
Associate Member, Filemaker Solutions Alliance


"Peter Pan" <splash@NOSPAMPLEASEmac.com> wrote in message
news:BBAAFF1B.1A969%splash@NOSPAMPLEASEmac.com...

> Hi,
>
> I have a text field with values such as:
>
> 12345/6
> 12345/85
> 12345/127
>
> There is always 5 characters before the /.
>
> I would like to get all the characters on the right hand side of the /,
> whether it is 1, 2, 3 characters etc. I've been playing with the position
> function but can't get it right - anyone know how this can be done?
>
> Many thanks in advance
>

[Peter Pan]

Thanks John, that was just what I was after, works a treat.

Many thanks

>
> You can figure out which characters come after your delimiter (the slash) by
> subtracting 6 (5 plus the slash itself) from the total number of characters
> in the string:
>
> Length(Your_Field)-6
>
> ...and you know they will always be on the right. Now you know how many
> characters you want, and you can use the Right() function to retrieve their
> value.
>
> --
> John Weinshel
> Datagrace
> Vashon Island, WA
> (206) 463-1634
> Associate Member, Filemaker Solutions Alliance
>
>
> "Peter Pan" <splash@NOSPAMPLEASEmac.com> wrote in message
> news:BBAAFF1B.1A969%splash@NOSPAMPLEASEmac.com...

>> Hi,
>>
>> I have a text field with values such as:
>>
>> 12345/6
>> 12345/85
>> 12345/127
>>
>> There is always 5 characters before the /.
>>
>> I would like to get all the characters on the right hand side of the /,
>> whether it is 1, 2, 3 characters etc. I've been playing with the position
>> function but can't get it right - anyone know how this can be done?
>>
>> Many thanks in advance
>>

>
>

[Glenn Schwandt]

One of many ways to do this, using the / as a delimeter and not relying on
the "always 5 characters before" part:

After (calculation, text) = Replace( text field, 1, Position( text field,
"/", 1, 1), "")

"Peter Pan" <splash@NOSPAMPLEASEmac.com> wrote in message
news:BBAAFF1B.1A969%splash@NOSPAMPLEASEmac.com...

> Hi,
>
> I have a text field with values such as:
>
> 12345/6
> 12345/85
> 12345/127
>
> There is always 5 characters before the /.
>
> I would like to get all the characters on the right hand side of the /,
> whether it is 1, 2, 3 characters etc. I've been playing with the position
> function but can't get it right - anyone know how this can be done?
>
> Many thanks in advance
>

[Glenn Schwandt]

Other possibilities:

= Middle( text field, Position( text field, "/", 1, 1), 9999)
= Right( text field, Length( text field) - Position( text field, "/", 1,
1))
= Substitute( text field, Left( text field, Position( text field, "/", 1,
1)), "")

All of which utilize the Position function. My original "Replace" solution
and the "Middle" solution above require only two functions each, so I would
assume they would be the most efficient.

"Glenn Schwandt" <schwandtgat@aoldot.com> wrote in message
news:voaomfod70b2f6@corp.supernews.com...

> One of many ways to do this, using the / as a delimeter and not relying on
> the "always 5 characters before" part:
>
> After (calculation, text) = Replace( text field, 1, Position( text field,
> "/", 1, 1), "")
>
> "Peter Pan" <splash@NOSPAMPLEASEmac.com> wrote in message
> news:BBAAFF1B.1A969%splash@NOSPAMPLEASEmac.com...

> > Hi,
> >
> > I have a text field with values such as:
> >
> > 12345/6
> > 12345/85
> > 12345/127
> >
> > There is always 5 characters before the /.
> >
> > I would like to get all the characters on the right hand side of the /,
> > whether it is 1, 2, 3 characters etc. I've been playing with the

position

> > function but can't get it right - anyone know how this can be done?
> >
> > Many thanks in advance
> >

>
>