Tip of the day - Failed IMPORT

[Greg Widdows]

Try a DIF (Date Interchange Format)
It works well with filePro.

Greg

Lerebours, Jose wrote:

>>Jerry Rains wrote:
>>
>>
>>>I learned something today.
>>>
>>>If you have a one line file that you are trying to IMPORT 
>>
>>and there is 
>>
>>>no LineFeed on the end the IMPORT will fail.
>>>
>>>By the same token.  I assume that if you have a multi-line file and 
>>>there is no LineFeed on the last line you will prematurely 
>>
>>finish the 
>>
>>>IMPORT without importing the last line.
>>>
>>>Something to watch out for.
>>>
>>>
>>
>>Jerry,
>>
>>This makes sense if you told it to look for a end-of-record 
>>marker and 
>>it was not there.  If you use other techniques to read the file or 
>>change the options for IMPORT it might not be an issue.
>>
> 
> 
> While in the subject, I just came across something I had never
> experienced.
> 
> I need to dynamically assign the field separator.  I have a group
> of users that have their excel saving CSV documents using semicolon (;)
> in lieu of commas (,).  Since others have it the right way, I need
> to have program switch according to user profile.
> 
> I have a dummy variable (no edit) holding a comma or a semicolon,
> using command   import ascii ref = (za) f=s  r=\n o=" c="
> I do not get the desired results.
> 
> Unfortunately, I cannot use the condition in the same line as an
> import command nor could I have the same import command twice.
> 
> What would be the remedy for something like this?
> 
> Regards;
> 
> 
> Jose Lerebours
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
>