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