Export to Excel

[Richard D. Williams]

If you are making a .csv file, I think you should try a carriage, chr("14").

i.e.
la="12345"
ha="Desc1 text"
hb="Desc2 text"
hc="Desc3 text"
lc="1234.33"

lb=ha&chr("14")&hb&chr("14")&hc

mgr(1)=la;mgr(2)=lb;mgr(3)=lc

If ha, hb, or lc is blank you should conditionalize the creation of lb.

Richard D. Williams

On 8/26/2018 5:16 PM, Scott Walker via Filepro-list wrote:
> When I do an export to excel what do I need to insert in the data stream to
> get excel to do jump to a new line in the current cell.
>
> In my filepro file I have desc1 and desc2 and desc3 as separate fields.
>
> In Excel I want to end up with them all in one cell but each one on a line
> by itself like:
>
> Part#	Description	List Price	
>
> 12345	Desc1 text	1234.33
> 	Desc2 text
> 	Desc3 text
>
>
>
> Regards,
> Scott Walker
>
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>
>
> ---
> This email has been checked for viruses by AVG.
> https://www.avg.com
>
>