Export with customvars onto one row

[Steven Barkess]

Hi

I want to produce an export feed that appears on one row only per product. I use some customvars, these all apear on seperate rows and as a result the feed is not to useful with out manipulation.

So, what is the quickest way to convert an export over several lines into one.

For example:

23 SEBASTIEN TELLIER LA RITOURNELLE VIRGIN
Record Label VIRGIN 0
Release Year Oct-04 0
Format 12" 0

to

23 SEBASTIEN TELLIER LA RITOURNELLE VIRGIN Oct-04 12"

or something like that...

Steven

[cdicken]

The attached word doc is a guide I did for converting a spreadsheet with custom fields in it and turning it into a hierarchical file. I guess you could try following the instructions - but in reverse.