Dorn wrote:
Unfortuantely I don't know if I am able to release all of our packaging sizes
and grades, however the attached text file shows the unique characters for
each type of data. If I could just find a way to split up the text into a
new row everytime it sees the word "productmaster" that would cut down on the
time it takes me to do this considerably. The text file below shows the
exact format of the information without line breaks. The full version just
has over 500 products with over 2000 grades. Just incase the text file won't
download here is an example for two products (with a total of 5 product
grades):

ProductMaster<ProductMaster Name="Actafoam(R)"<Product Grade="F2,
Powder"<Grade SKU="0115791"<c266.138 lb drum</c2<c30115791</c3<c4
null="1"</c4<c5 null="1"</c5</Grade</Product<Product Grade="R-3"<Grade
SKU="0114873"<c2449.7384 lb drum</c2<c30114873</c3<c4 null="1"</c4<c5
null="1"</c5</Grade</Product</ProductMaster<ProductMaster
Name="Acudyne"<Product Grade="180, 48 solid"<Grade SKU="0113541"<c2473.99
lb drum</c2<c30113541</c3<c4 null="1"</c4<c5
null="1"</c5</Grade</Product<Product Grade="DHR, 48 solid"<Grade
SKU="0113550"<c2473.99 lb drum</c2<c30113550</c3<c4 null="1"</c4<c5
null="1"</c5</Grade</Product<Product Grade="SCP 25% Solid"<Grade
SKU="0113548"<c2473.99 lb drum</c2<c30113548</c3<c4 null="1"</c4<c5
null="1"</c5</Grade</Product</

As you can see the letters "productmaster" is an identifier of a new
product, "product grade" is an identifier of a new grade and so on. If I
could at least break it up a little bit into cells I could go through with
the asap utility and clean it up. I don't expect this to be quick, just
quicker.

Thanks!

"wjohnson" wrote:

Where does the "original" information come from? If possible can you
include a sample of it, i.e. HTML or whatever.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=495673


Dorn

1. What software generated the file? Do you have control of that
software such that you could see if it has other export formats that
might result in 1 row per item?
2. You may want to investigate opening the file in WORD and using Find |
Replace to replace "<productmaster" with "Line Break + <productmaster"

Texas Handly