Tip of the day - Failed IMPORT

Lerebours, Jose Jose.Lerebours at EagleGL.com
Fri Jun 17 11:22:17 PDT 2005


> 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


More information about the Filepro-list mailing list