I figured out half of the solution. Just need to know how to parse
SKU|1234566
name|Polynesian Fish Lifestyle Shirt
description|60% Cotton, 40% Rayon.Available in Marine and Pine, and in sizes
S-XXL. color|<select name="HOO-M011062-color"><option
value="Marine">Marine<option value="Pine">Pine</select>
size|<select name="HOO-M011062-size"><option value="S">S<option
value="M">M<option value="L">L<option value="XL">XL<option
value="XXL">XXL</select>
price|4399
title|Polynesian Fish Lifestyle Shirt from Sportailer Inc.'s.
image|/clothing/polynesianfish.jpg
category|clothing
vendor|hookandtackle
shippinginfo|Shipping for this clothing item is $5.25 if your total clothing
order is under $100. Shipping is free if your total clothing order exceeds
$100.
title2|Cargo Shorts, Short, Hawaiian, Tropical Shirt, Clothing at White
Marlin Designs

I am looking for a solution to parse the | delinitaed string . I know I can
do using cfloop but dont want to do that becuase my file has about 200
products similar to above. I allready have a cfloop seperating each product.
Now inside that product I have seperate the fields and values for them and
then insert in database. The deliminator here is | (pipe)

Above say example:

category|clothing

category is the field name and clothing is the value for that caetgory
field. Which is seprated by | (pipe)


Ketan Patel

  -----Original Message-----
  From: Ben Doom [mailto:[EMAIL PROTECTED]
  Sent: Thursday, December 11, 2003 9:55 AM
  To: CF-RegEx
  Subject: Re: Regular _expression_ help on parsing.

  Heh.  I can parse nothing in no time!  Literally!

  --Ben Doom

  Ketan Patel wrote:

  > Hi All,
  > I have text file which has about 200 products similar to this:
  >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to