Importing/exporting data with carriage returns (I Think)

Fri Aug 25 21:58:29 PDT 2017

Notepad++ can be used to change EOLs from CR/LF to LF and back again.

The returns are in multiple places within the cell, can notepad++ search 
for them and change them?

When I look at them in excel it looks like they did a couple of carriage 
returns between paragraphs within the cell.

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.

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.

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.

Mike

On 8/25/2017 5:04 PM, Boaz Bezborodko wrote:
> Top post:
>
> Why not import using "new line" for new record?
>
> From the manual:
>
> ASCII:
>
>        Then: import ASCII name R=r F=f O=o C=c
>
> or:
>
>        Then: import ASCII name=pathname R=r F=f O=o C=c
>
> 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.
>
> "r" is record separator
> "f" is field separator
> "o" is opening field delimiter
> "c" is closing field delimiter.
>
> Example:
>
>  Then: IMPORT ASCII test=test.txt R=^J f=\^
>
> ....
>
> IMPORTANT:You may use a few special codes with the IMPORT ASCII format 
> to identify delimiters or field separators:
>
> \r for carriage return
> \f for form feed
> \n for new line
> \t for tab
>
>
>
> Notepad++ can be used to change EOLs from CR/LF to LF and back again.
>
> Boaz
>
>
>> Message: 3
>> Date: Fri, 25 Aug 2017 15:10:31 -0400
>> From: Mike Fedkiw<mfedkiwfp at gmail.com>
>> To: Chris Rendall<crendall at teamind.com>,	0 Filepro List
>> 	<filepro-list at lists.celestial.com>
>> Subject: Re: Importing/exporting data with carriage returns (I Think)
>> Message-ID:<811ddc9d-6dbb-ef53-2079-6a936b9ad2f5 at gmail.com>
>> 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:
>>
>>> 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 [mailto:filepro-list at lists.celestial.com]
>>> Sent: Friday, August 25, 2017 11:33 AM
>>> To: 0 Filepro List<filepro-list at lists.celestial.com>
>>> 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
>>> Filepro-list at lists.celestial.com
>>> Subscribe/Unsubscribe/Subscription Changeshttp://mailman.celestial.com/mailman/listinfo/filepro-list
>>> _______________________________________________
>>> Filepro-list mailing list
>>> Filepro-list at lists.celestial.com
>>> Subscribe/Unsubscribe/Subscription Changes
>>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>
>
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon> 
> 	Virus-free. www.avast.com 
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link> 
>
>
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170826/f3d7e96a/attachment.html>