<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
I was going to suggest the opposite. Make sure the file is saved
with all records ending in LF only, not CR/LF, and IMPORT using LF
as the record separator. Then all CRs are captured with the
imported notes.<br>
<br>
(Notepad++ has an option to view all characters so you can see what
special characters are in the file.)<br>
<pre class="moz-signature" cols="72">
</pre>
<div class="moz-cite-prefix">On 8/26/2017 12:58 AM, Mike Fedkiw
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:dc15238c-5489-5221-4672-0cda50df9d80@gmail.com">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<font size="+1" color="#3333ff">Notepad++ can be used to change
EOLs from CR/LF to LF and back again.<br>
<br>
</font>The returns are in multiple places within the cell, can
notepad++ search for them and change them? <br>
<br>
When I look at them in excel it looks like they did a couple of
carriage returns between paragraphs within the cell.<font
size="+1"><br>
<br>
</font>This is an example of the data contained in one of the
cells I'm trying to import. This one is only two paragraphs but
others contain more.<br>
<br>
<table cellspacing="0" cellpadding="0" width="1386" border="0">
<colgroup><col width="1386"></colgroup><tbody>
<tr height="20">
<td class="xl65" style="height:15.0pt;width:1040pt"
height="20" width="1386">A lack of electrolytes in
aquarium freshwater may cause serious health problems for
freshwater fish. API AQUARIUM SALT supplies electrolytes
to improve fish respiration. Made from evaporated sea
water and containing natural active ingredients such as a
natural fish tonic, API AQUARIUM SALT promotes the overall
health of your fish by improving their gill function and
reducing stress in a freshwater aquarium. This all-natural
salt provides the essential electrolytes fish need for the
uptake of oxygen and release of carbon dioxide and ammonia
through the gills. API AQUARIUM SALT should only be added
to reduce stress during new freshwater aquarium setup and
water changes or to promote disease recovery when solving
specific fish health issues. Use API AQUARIUM SALT when
setting up a new freshwater aquarium, when changing water
or treating disease. Make sure to take extra care when
using salt with live plants, as some plants may be
sensitive.<br>
<br>
With API Aquarium products, it?s easy to keep a beautiful
saltwater, freshwater or reef aquarium. For over 50 years,
API has been creating innovative, research-driven
solutions that make it easier to care for your fish and
aquarium. API Aquarium Treatment Supplies are designed to
work in conjunction with each other to provide best
results to control algae, promote healthy bacterial growth
and help control and cure fish diseases and conditions
such as ich and fin rot. They work to provide a safe,
hospitable environment for fish such as tropical community
fish, cichlids, goldfish and more. With API, you can spend
more time admiring your fish, and less time scrubbing your
tank. Make sure to use all products as directed in order
to ensure the best results.</td>
</tr>
</tbody>
</table>
<font size="+1"><br>
Mike<br>
</font><br>
<div class="moz-cite-prefix">On 8/25/2017 5:04 PM, Boaz Bezborodko
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:be1fe303-8e3b-8edc-03d5-423d30fe5e36@mirrotek.com">
<meta http-equiv="Content-Type" content="text/html;
charset=utf-8">
Top post:<br>
<br>
Why not import using "new line" for new record?<br>
<br>
From the manual:<br>
<br>
<p><font style="font-family: 'Times New Roman'; font-weight:
bold;" face="Times New Roman" color="#010100">ASCII:</font><font
style="font-family: 'Times New Roman';" face="Times New
Roman" color="#010100"> </font></p>
<p><font style="font-family: 'Times New Roman';" face="Times New
Roman" color="#010100"> Then: import ASCII name R=r
F=f O=o C=c</font></p>
<p><font style="font-family: 'Times New Roman';" face="Times New
Roman" color="#010100">or:</font></p>
<p><font style="font-family: 'Times New Roman';" face="Times New
Roman" color="#010100"> Then: import ASCII
name=pathname R=r F=f O=o C=c</font></p>
<p style="margin-top: 0; margin-bottom: 0;"> </p>
<p><font style="font-family: 'Times New Roman';" face="Times New
Roman" color="#010100">where "name" is the name of the
import file and "pathname" is a full or relative pathname.
Use the pathname option when the merge file is not in the
current directory.</font></p>
<p style="margin-top: 0; margin-bottom: 0;"> </p>
<p style="margin-left: 36.00pt;"><font style="font-family:
'Times New Roman';" face="Times New Roman" color="#010100">"r"
is record separator<br>
"f" is field separator<br>
"o" is opening field delimiter<br>
"c" is closing field delimiter.</font></p>
<p style="margin-top: 0; margin-bottom: 0;"> </p>
<p><font style="font-family: 'Times New Roman'; font-size: 8pt;"
size="2" face="Times New Roman" color="#010100">Example:</font></p>
<p><font style="font-family: 'Times New Roman'; font-size: 8pt;"
size="2" face="Times New Roman" color="#010100"> Then:
IMPORT ASCII test=test.txt R=^J f=\^ </font></p>
....<br>
<br>
<p><font style="font-family: 'Times New Roman'; font-weight:
bold;" face="Times New Roman" color="#010100">IMPORTANT:</font><font
style="font-family: 'Times New Roman';" face="Times New
Roman" color="#010100"> You may use a few special codes with
the IMPORT ASCII format to identify delimiters or field
separators: </font></p>
<p style="margin-left: 66.50pt;"><font style="font-family:
'Times New Roman';" face="Times New Roman" color="#010100">\r
for carriage return <br>
\f for form feed <br>
\n for new line <br>
\t for tab </font></p>
<br>
<br>
Notepad++ can be used to change EOLs from CR/LF to LF and back
again.<br>
<br>
Boaz<br>
<br>
<br>
<blockquote type="cite"
cite="mid:mailman.1419.1503693023.5505.filepro-list@lists.celestial.com">
<pre wrap="">Message: 3
Date: Fri, 25 Aug 2017 15:10:31 -0400
From: Mike Fedkiw <a class="moz-txt-link-rfc2396E" href="mailto:mfedkiwfp@gmail.com" moz-do-not-send="true"><mfedkiwfp@gmail.com></a>
To: Chris Rendall <a class="moz-txt-link-rfc2396E" href="mailto:crendall@teamind.com" moz-do-not-send="true"><crendall@teamind.com></a>, 0 Filepro List
<a class="moz-txt-link-rfc2396E" href="mailto:filepro-list@lists.celestial.com" moz-do-not-send="true"><filepro-list@lists.celestial.com></a>
Subject: Re: Importing/exporting data with carriage returns (I Think)
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:811ddc9d-6dbb-ef53-2079-6a936b9ad2f5@gmail.com" moz-do-not-send="true"><811ddc9d-6dbb-ef53-2079-6a936b9ad2f5@gmail.com></a>
Content-Type: text/plain; charset=utf-8; format=flowed
Okay, so if I remove the carriage returns before importing the data
using xlate I'm assuming it would all just wind up as a continuous line
of data. If that's right, is there any way of importing the data
retaining the spacing between the data so it'll be there when exported.
Although I've already had issues with the data not exporting after the
first carriage return last time I tried it.
Mike
On 8/25/2017 1:58 PM, Chris Rendall via Filepro-list wrote:
</pre>
<blockquote type="cite">
<pre wrap="">You can use the XLATE command to remove the carriage return in a CSV import.
When I use the import command I set the name to "rec": import ascii rec=/home/chris/list.csv r=\n f=,
Then to remove the carriage return I use: rc=xlate(rec(14),chr("13"),"")
The number 14 inside rec(14) is the number of the field you are importing. If every field has a carriage return in them you will need to use xlate for every field, rec(1), rec(2), and so on for the number of fields you are importing per record. On Linux when I'm importing a CSV file from Windows I just need to run the xlate command on the last field I'm importing.
-- Chris
-----Original Message-----
From: Mike Fedkiw via Filepro-list [<a class="moz-txt-link-freetext" href="mailto:filepro-list@lists.celestial.com" moz-do-not-send="true">mailto:filepro-list@lists.celestial.com</a>]
Sent: Friday, August 25, 2017 11:33 AM
To: 0 Filepro List <a class="moz-txt-link-rfc2396E" href="mailto:filepro-list@lists.celestial.com" moz-do-not-send="true"><filepro-list@lists.celestial.com></a>
Subject: Importing/exporting data with carriage returns (I Think)
win-server 2008 r2/filepro 5.0.09dn9
Can someone tell me how or what I can do to import data into filepro that has carriage returns within the data cells?
I receive these nice XLS files from my vendors with extended descriptions for things that I want to get into a memo fields in filepro but I'm having all sorts of issues trying to make that happen.
Usually after setting up the XLS file to the way it needs to be for the import I'd save it as a DXF file. That's been working just fine for quite some time but when a cell contains returns I get an error message saying it's not a valid DXF file. I also tried saving it as a CSV file and importing that but the cells with the returns didn't import at all when I tried that. And I'm not even sure I'm saving it as the correct type of CSV(Comma delimited CSV or MS-DOS CSV) for importing it.
Even if I get the import figured out if the data does have and returns within the memo it seems to stop exporting that fields data after the first one.
If at all possible, I would really like to maintain the returns because it makes it much easier to read the data in the memo and it would also make the exported data much nicer too read with them included.
AND...instead of me sitting here trying to figure this out for another week or so like I just did with all the MEMO stuff, I'd just assume pay someone to set it up for me. If someone is interested in doing that, let me know.
Mike
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com" moz-do-not-send="true">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes <a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list" moz-do-not-send="true">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com" moz-do-not-send="true">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list" moz-do-not-send="true">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<br>
<div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top: 1px solid #D3D4DE;">
<tbody>
<tr>
<td style="width: 55px; padding-top: 13px;"><a
href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon"
target="_blank" moz-do-not-send="true"><img
src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif"
alt="" style="width: 46px; height: 29px;"
moz-do-not-send="true" height="29" width="46"></a></td>
<td style="width: 470px; padding-top: 12px; color:
#41424e; font-size: 13px; font-family: Arial,
Helvetica, sans-serif; line-height: 18px;">Virus-free.
<a
href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link"
target="_blank" style="color: #4453ea;"
moz-do-not-send="true">www.avast.com</a> </td>
</tr>
</tbody>
</table>
<a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1"
height="1" moz-do-not-send="true"> </a></div>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>