Extract flat file info from CSV column
Posted: Tue Sep 16, 2008 7:17 pm
Greetings,
I have found one of the hardest things so far. How do you extract information from a column of a csv file so you can create more columns with it?
Example: (description column)
<BODY background = "http://www.xxxx.com/wall.gif" TEXT="#000000"><font face="Arial"><B> FMF POWERCORE S SLIP-ON TTN/TITANIUM BRONZE KAW #042030 042030 [M 02847]</B><P><B>Brand: </B>FMF<P><B>Description: </B>FMF POWERCORE S SLIP-ON TTN/TITANIUM BRONZE KAW #042030<P><B>Manufacturer`s #: </B>042030<P><H5>Photo is not available. Please look on Manufacturer`s Website if the link is listed below.</H5><BR><H5>Descriptions are generic. Read TITLE and any NOTES under title carefully. Please e-mail us if you have any questions.</H5><P>FMF Powercore S Slip-On TTN/Titanium Bronze KAW #042030<P><B>Our store price: $260.95</B><P>Suggested retail: $399.99<P>This is a closeout item - no returns - no refunds - no exchanges<P>`Quantity Available` at the top of the page is for reference only.<BR>Our items are listed once a month and are in stock at the time they are listed.<BR>There were 5 available when this item was listed.<P>All our items are brand new<p><B>Order #: M 02847</B><P>Vendor order #: 18110012 <P><B>For more information - Go to the Manufacturer`s Website: </B> <A HREF="http://www.xxxx.com/ "> <B> Click Here</B></A><P>Brand: <B>FMF</B> Category: <B>EXHAUST</B><P>Click here for our complete <A href="http://www.xxxx.com/MAWINDX.HTM">eBay Store Directory</A> of all the brands and products we carry in our eBay store.<BR> Plus our Return and Exchange policy - FAQs - Combined shipping - Shipping times.<P>Search in our store using the Brand name - Manufacturer`s number or Vendor`s number.<BR>Use ONLY Alpha-Numeric Characters ( no - / # or spaces ).<BR>Be sure to check "search <B> in titles and descriptions </B> box" before starting your search.<P><H5>If this is not the exact item you want please e-mail us or call us at 1-800-xxx-xxxx.<P>We have been in the mail order business since 1976 - over 30 years. <BR>Our eBay store was opened in June of 2005. We have a high feed back score <BR>and excellent seller rating. Please call us at 1-800-xxx-xxxx if you have any questions. <BR>We carry thousands of new parts and accessories for your bike.<BR><P>Orders originated on eBay must go through eBay`s order system for proper eBay fee collection.<BR><P>Note: We only ship into the United States and Canada. Foreign customers may want use a U.S. freight forwarder.<P></font>
Now, must of the information is BLAH BLAH BLAH. I am looking to pull information on the actual description, brand, color, size, or more. Our client said this column is how they send it to eBay, but to me it looks like the flat file from turbo lister from eBay. any information would be greatly appreciated and will be credited in programming.
I have found one of the hardest things so far. How do you extract information from a column of a csv file so you can create more columns with it?
Example: (description column)
<BODY background = "http://www.xxxx.com/wall.gif" TEXT="#000000"><font face="Arial"><B> FMF POWERCORE S SLIP-ON TTN/TITANIUM BRONZE KAW #042030 042030 [M 02847]</B><P><B>Brand: </B>FMF<P><B>Description: </B>FMF POWERCORE S SLIP-ON TTN/TITANIUM BRONZE KAW #042030<P><B>Manufacturer`s #: </B>042030<P><H5>Photo is not available. Please look on Manufacturer`s Website if the link is listed below.</H5><BR><H5>Descriptions are generic. Read TITLE and any NOTES under title carefully. Please e-mail us if you have any questions.</H5><P>FMF Powercore S Slip-On TTN/Titanium Bronze KAW #042030<P><B>Our store price: $260.95</B><P>Suggested retail: $399.99<P>This is a closeout item - no returns - no refunds - no exchanges<P>`Quantity Available` at the top of the page is for reference only.<BR>Our items are listed once a month and are in stock at the time they are listed.<BR>There were 5 available when this item was listed.<P>All our items are brand new<p><B>Order #: M 02847</B><P>Vendor order #: 18110012 <P><B>For more information - Go to the Manufacturer`s Website: </B> <A HREF="http://www.xxxx.com/ "> <B> Click Here</B></A><P>Brand: <B>FMF</B> Category: <B>EXHAUST</B><P>Click here for our complete <A href="http://www.xxxx.com/MAWINDX.HTM">eBay Store Directory</A> of all the brands and products we carry in our eBay store.<BR> Plus our Return and Exchange policy - FAQs - Combined shipping - Shipping times.<P>Search in our store using the Brand name - Manufacturer`s number or Vendor`s number.<BR>Use ONLY Alpha-Numeric Characters ( no - / # or spaces ).<BR>Be sure to check "search <B> in titles and descriptions </B> box" before starting your search.<P><H5>If this is not the exact item you want please e-mail us or call us at 1-800-xxx-xxxx.<P>We have been in the mail order business since 1976 - over 30 years. <BR>Our eBay store was opened in June of 2005. We have a high feed back score <BR>and excellent seller rating. Please call us at 1-800-xxx-xxxx if you have any questions. <BR>We carry thousands of new parts and accessories for your bike.<BR><P>Orders originated on eBay must go through eBay`s order system for proper eBay fee collection.<BR><P>Note: We only ship into the United States and Canada. Foreign customers may want use a U.S. freight forwarder.<P></font>
Now, must of the information is BLAH BLAH BLAH. I am looking to pull information on the actual description, brand, color, size, or more. Our client said this column is how they send it to eBay, but to me it looks like the flat file from turbo lister from eBay. any information would be greatly appreciated and will be credited in programming.