Imort Excel File

Are you comfortable using Excel? If so; Insert 2 new coulmns to the right of description, which is Column A for this example. Enter the formula shown in the first row for each new column (just type it into the cell) and then pull it down using the autofill handle (hold the cursor over the bottom right corner of the cell until the cursor tuns to a + then click, hold and drag down)

Description NewDescription ExtDescription Aquarium 55 gallon black w/ 2 overflows =LEFT(A2,28) =MID(A2,29,LEN(A2)-28) Instant Ocean salt 50 gallon bag

will give you this

Description NewDescription ExtDescription Aquarium 55 gallon black w/ 2 overflows Aquarium 55 gallon black w/ 2 overflows Instant Ocean salt 50 gallon bag Instant Ocean salt 50 gallon bag

That is a real brief description, so post back if you need more help.

Marc

The best way to do this is with a SQL query and import the items into a temp table then copy from temp table to items table.

Marc

Thanks for the formula. I tried it and the formula works. But I need someth> Are you comfortable using Excel? If so;

Maurice,

I am not experienced > The best way to do this is with a SQL query and import the items into a temp

Khalid,

It seems to me you want to split the description up by whole words. You could do it, but I don't think it could be done with Excel worksheet functions, it would probably take a little VBS coding. Off the top of my head, I think you would have to read through the description and check for characters and then split it up based on where they are. If is not simple, not for me anyway ;)

It may easier to do in a table as Maurice suggests, but I can't think of a way easy enough to explain out, nor can I even think of any easy way at this minute (it's been along day).

Maybe one of the more experienced guys will have a better suggestion?

Good Luck,

Marc

Do you want all the description to be moved to the extended description or just the part of text exeding 28 caracters?

Sacha

Hi, An example of SQL scripting (I set the length variable also, I think that the item description is 30 char in RMS):

DECLARE @Name VARCHAR(100) DECLARE @Length INT DECLARE @Counter INT DECLARE @Space INT

SET @Name = 'First word Second word Third word and so on' SET @Length = 28 SET @Counter = @Length

WHILE @Counter 0 BEGIN SET @Space = (SELECT CHARINDEX(' ',SUBSTRING(@Name,@Counter,@Length-@Counter))) SET @Counter = @Counter - 1 IF @Space>0 BREAK END IF @Space>0 SELECT LEFT(@Name,@Counter) AS Description ELSE SELECT LEFT(@Name,@Length) AS Description IF @Space>0 SELECT Right(@Name,LEN(@Name)-@Counter-1) AS ExtendedDescription ELSE SELECT @Name AS ExtendedDescription

__________ Information from ESET Smart Security, version of virus signature database 4063 (20090508) __________

The message was checked by ESET Smart Security.