Export Multiple Fields of Data to One Excel Cell

[Kenneth Brody]

On 4/26/2012 4:53 PM, Scott Walker wrote:
>> I have a file with part#, description line 1, description line 2 and
>> description line 3
>>
>> I want to export these fields to a csv file and then import it into excel
>>
>> I want part# to be in column a and the three lines of description to all
>> be in column b.
>>
>>
>> Sort of like:
>>
>>
>> Part#		Description
>>
>> 123434		Description Line One Text
>> 		Description Line Two Text
>> 		Description Line Three Text
>>
>> 3322222	Description Line One Text
>> 		Description Line Two Text
>>
>> Is this possible.
>>
> To be more precise,  I want all the description lines to be in one Excel
> cell.

A quick test with Excel 2007 shows that you can put a multi-line string 
inside of quotes, and it imports it as a single cell from a CSV file.

You should be able to simply put all of the description lines into a single 
filePro field -- use CHR("10") to insert a line-break -- and export it as usual.

-- 
Kenneth Brody