On Sat, 8 Oct 2011 13:19:43 -0600 "S. Dale Morrey" <[email protected]> wrote:
> Ok I'll admit it, I suck at regex. > Unfortunately, I now have the task of importing a customers catalog > price list into a database and I'm not sure where to begin. > I really think a simple regex could convert the whole thing to a CSV > and I could then import the CSV directly. > > Here is an example of what I'm looking at. > Item Item Description Page # Retail Member Wholesale Pkg > 12137 HOLIDAY PENGUIN FIGURINES 335 9.95 4.25 5.95 1 PR > > As you can see all the fields are separated by whitespace, but then > again so are the individual words in the description. I wonder what kinds of white space? For example, are the fields delimited by tabs, so that the item description field can contain spaces. If so, a simple split on \t would do you nicely. Perl has an excellent CSV library, which would make exporting to CSV very easy. -- Charles Curley /"\ ASCII Ribbon Campaign Looking for fine software \ / Respect for open standards and/or writing? X No HTML/RTF in email http://www.charlescurley.com / \ No M$ Word docs in email Key fingerprint = CE5C 6645 A45A 64E4 94C0 809C FFF6 4C48 4ECD DFDB /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
