> I have a sqlite column with a string. This string is composed by n > different lines separated by an \n character. Each line is composed by > <key>: <value>. So my final string is something like this: > > <key_1>: <value_1_bla_bla>\n > <key_2>: <value_2_bla_bla>\n > <key_3>: <value_3_bla_bla> > > Now I need to search *only* inside a particular key value. For example > I would to see if the value of key_2 contains a string 'test' (and if > possible return the entire value of key key_2). > Is it possible? My solution is to use regular expression (anyone can > hep me? I don't know more about them).
That would work fine. You could easily create a user defined function and use the regular expression lib in it. Google search shows articles on using regex in python, ruby, and php so you might be able to find something already worked out for your use.
