Export Multiple Fields of Data to One Excel Cell

[Kenneth Brody]

On 4/26/2012 8:34 PM, Scott Walker wrote:
> Richard,
>
> Because I want them to appear as separate lines in the SAME cell.

Do as I said in my first reply, concatenate them together into a single 
field, using CHR("10") to break them into separate lines.

>
> Regards,
>
> Scott
>
>> -----Original Message-----
[...]
>> On Behalf Of Richard Kreiss
[...]
>>
>> Scott
>>
>> Why not concatenate the descriptions into one dummy field and export that?
>>
>> Richard
[...]
>>>> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
>>>> On 4/26/2012 6:36 PM, Scott Walker wrote:
>>>>>> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
>>>> [...]
>>>>>> 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.
>>>>>
>>>>> Ken,
>>>>>
>>>>> Thanks for taking a shot but that just does not work for me.  I
>>>>> found that from the keyboard, Excel uses<Alt><Enter>   as it's soft
>> return.
>>>>> Maybe someone could tell me the codes for that I can try inserting
>>>>> them into the file.
>>>>
>>>> "DDW".
>>>>
>>>> Try the attached CSV file.
>>>
>>> Very interesting.  When I open it the "extra" lines of description do
>>> not show.  But if I go into one of the description cells and start
>>> editing it, all for lines of description are displayed.  Excel is
>>> weird!  Can you show me the fp code you used to generate this csv file.

-- 
Kenneth Brody