Importing into excel with a line break WITHIN the cell

[Joe Chasan]

It's certainly ugly prorgramming, but if you specify both an opening
and closing field delimiter it should be possible.

Just wrote this quick test - 4 field file

export word test=("/tmp/myfile.csv") o=" c=" f=, r=\n
test(1)=1 
test(2)=2{chr("13"){3{chr("13"){4 

produces what I think you want.

chr("13") is Carriage-Return character, so put that between each of your
description fields.

-joe

On Fri, Dec 08, 2023 at 04:53:41PM +0000, Scott Walker via Filepro-list wrote:
> I've fiddled with this in the past and don't think I ever got it working correctly, but I'm about to try again so I thought I'd ask:
> 
> I have a database with (10) separate fields for the item description (Description Line 1, Description Line 2, Description Line 3, etc).  I want to export the data to a text file that will be imported into Excel.
> 
> I want all 10 description fields to end up in a single cell in excel with each line of description on it's own line but all in the same cell.
> 
> If I was typing it into Excel I would type the first line of description then <ALT><Enter> to start the next line of description in the SAME CELL.
> 
> What would I need to insert in the data stream coming from filePro to achieve the same result.
> 
> Regards,
> Scott
> 
> 
> 
> 
> 
> 
> Scott Walker
> RAM Systems Corp.
> scott.walker at ramsystemscorp.com<mailto:scott.walker at ramsystemscorp.com>
> Cell:  (704) 619-3757
> 
> 
> 
> 
> 
> 
> 
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20231208/047a86e0/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at mailman.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
-joe

--
-Joe Chasan-                           Magnatech Business Systems, Inc.
joe - at - magnatechonline -dot- com   Plainview, NY - USA
https://www.MagnatechOnline.com        Tel.(516) 931-4444
Proud member of iXorg                  Fax.(516) 931-1264