suppose you have a text file that contains : Myname,yourname hisname Myname,yourname hisname Myname,yourname hisname Myname,yourname hisname Myname,yourname hisname Myname,yourname hisname Myname,yourname hisname .... notice that this is an irregular format, because the first column delimiter is a comma, and the second is a space. this kind of file cannot be parsed easily using "standard" formats like CSV. A regular expression allows you to break down the lines into columns in an ad hoc fashion. the expression : (\w+),(\w+) (\w+) will break lines into three columns, for example, based on a comma and space delimiter. the parentheses are essential, to provide subgroups that map to the columns. try the example above, it should become clearer. if you do not now how to use Perl regular expressions, you need to do some background reading first. regards,mike
________________________________ From: Noah Hart [mailto:[EMAIL PROTECTED] Sent: Tue 27/2/2007 6:59 PM To: sqlite-users@sqlite.org Subject: [sqlite] Singular Sqlite3Explorer 2.0 question Has anyone used this program? I am trying to use the "Import using Regular Expression" option. Itis looking for some type of regular expression to parse the columns. Any suggestions or sample expressions you can offer? Regards, Noah Hart CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ -----
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
