Link to home
Start Free TrialLog in
Avatar of terrypba1
terrypba1

asked on

Exporting a CR/LF from Foxpro to XLS

I need to export data from a VFP9 table to an .xls file.
One field in the xls file will be receiving two address lines, and needs the ALT Enter Code to create a CR/LF.
Can I put that code in the export file--
e.g.
select  Line1 + ?? + Line 2 as address1

Alternatively can I export something like "xy" to mark the break and then search and replace in the xlsx?. Seems simple but when I use CTRL J or ALT 0010 as the replace character, I end up with a blank line between Line 1 and Line 2.
ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of terrypba1
terrypba1

ASKER

Perfect! Thanks pcelba!