Rails - Aug 2011 - searching tables for a pattern that is in some other text

suppose I have a text file and I am looking for a pattern in that file
of the regex form: /^\s*#{label}\s*:?\s*(.*)/i
Where ''label'' is a variable, but I want to do something like
this:

labels.each do |lab|
  if line =~ /^\s*#{lab}\s*:?\s*(.*)/i
    matched = lab
  end
end

If labels are stored in the database, is there a good faster way to do
this ?

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On Aug 23, 11:05 am, Jedrin
<jrubia...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> suppose I have a text file and I am looking for a pattern in that file
> of the regex form: /^\s*#{label}\s*:?\s*(.*)/i
> Where ''label'' is a variable, but I want to do something
like this:
>
> labels.each do |lab|
>   if line =~ /^\s*#{lab}\s*:?\s*(.*)/i
>     matched = lab
>   end
> end
>
> If labels are stored in the database, is there a good faster way to do
> this ?
Postgresql understands the SIMILAR TO command, which uses a SQL
version of regular expressions:
http://www.postgresql.org/docs/8.3/static/functions-matching.html

Not sure if that is general SQL or postgres specific though, and I''d
also image the SQL regular expressions are a little less powerful, but
you may be able to accomplish what you want.

\Peter

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.