errors within an exported .slk file

[Walter D Vaughan Jr]

As a single character delimiter we've used either a tilde ~ or the pipe | 
Works 99% of the time. 


> -----Original Message-----
> From: filepro-list-bounces+wvaughan=steelerubber.com at lists.celestial.com
> [mailto:filepro-list-
> bounces+wvaughan=steelerubber.com at lists.celestial.com] On Behalf Of
> Mike Fedkiw
> Sent: Sunday, July 20, 2014 4:32 PM
> To: Filepro list
> Subject: Re: errors within an exported .slk file
> 
> Actually a CSV file is where I started with a different export but I just
couldn't
> get it to work because of asterisks, commas and semicolons within the
field I
> wanted to export. That's why I went to the SLK file, it didn't care about
any of
> that. I think it's kinda ridiculous that it can be so difficult to export
stuff like
> I'm trying to. It's like use slk for this one but use something different
for
> another and I haven't really done much exporting anyway. Can't wait until
I
> need to find a third way to export something, this just sucks.
> 
> Mike
> 
> On Jul 19, 2014, Terry Graham <terryg at tlgsb.com>
> wrote:
> >I wouldn't use a .slk file which has lots of Excel parameters.  Just
> >use a .csv file.  I do it all the time.
> >
> >Terry Graham
> >
> >
> >On 7/19/2014 4:11 PM, Mike wrote:
> >> I have created files just like this in the past but every time I
> >create
> >> one from this file, it has tons of errors when I try opening it with
> >> excel2003. This is a simplified processing table and it still getthe
> >errors.
> >>
> >> This is exactly what the errors say
> >>
> >> cannot read record 688114.
> >> continue reporting each error?
> >>
> >> Microsoft office excel cannot convert some of the cells. The total
> >> number of errors found is 688114
> >>
> >> There's only 42,187 records in the file
> >>
> >> I also ran a process to clean up any junk or empty records while
> >copying
> >> the good ones into a new file. I also turned on the browse and
> >scanned
> >> through the records but didn't see any garbage within it
> >>
> >> this is ole line of what the data looks like
> >> 10001310    0025    10004567
> >> each of those is a separate column within the output file
> >>
> >> I just don't get it
> >>
> >>
> >>
> >> start  ? If: 1 eq ""
> >>          Then: end
> >> 2  -------   -   -   -   -   -   -   -
> >>          ? If: 26 eq ""
> >>
> >>   1.         Then: end
> >>
> >> 3  -------   -   -   -   -   -   -   -
> >>          ? If: 8 eq ""
> >>          Then: end
> >> 4  -------   -   -   -   -   -   -   -   -   -   -   -
> >>        ? If:
> >>        Then: export multi disfile=c:\export\discfile.slk
> >> 5  -------   -   -   -   -   -   -   -   -   -   -   -
> >>        ? If:
> >>        Then: disfile(1)=1
> >> 6  -------   -   -   -   -   -   -   -   -   -   -   -
> >>        ? If:
> >>        Then: disfile(2)=26
> >> 7  -------   -   -   -   -   -   -   -   -   -   -   -
> >>        ? If:
> >>        Then: disfile(3)=8
> >> 8  -------   -   -   -   -   -   -   -   -   -   -   -
> >>        ? If:
> >>        Then: end
> >> -------------- next part -------------- An HTML attachment was
> >> scrubbed...
> >> URL:
> >http://mailman.celestial.com/pipermail/filepro-list/attachments/2014071
> >9/fe8e8fd3/attachment.html
> >> _______________________________________________
> >> Filepro-list mailing list
> >> Filepro-list at lists.celestial.com
> >> Subscribe/Unsubscribe/Subscription Changes
> >> http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>
> >>
> 
> -- Sent with K-@ Mail - the evolution of emailing.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
http://mailman.celestial.com/pipermail/filepro-list/attachments/20140720/c78
9fcc0/attachment.html
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list