Importing into excel with a line break WITHIN the cell

[Scott Walker]

Joe,

Good to hear from you.  Thanks for your input.  Maybe that works for your because your are using export WORD.  For some reason this code uses export ASCII.

I'll give your way a try.

Regards,
Scott





-----Original Message-----
From: Joe Chasan <joe at magnatechonline.com> 
Sent: Friday, December 8, 2023 6:09 PM
To: Scott Walker <scott.walker at ramsystemscorp.com>
Cc: filepro-list at lists.celestial.com <filepro-list at aws-01.celestial.com>
Subject: Re: Importing into excel with a line break WITHIN the cell

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/20231
> 208/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