Re: Splitting/Combing data question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Stuart (sg_booth_at_hotmail.com)
Date: 03/01/04 

Date: Mon, 1 Mar 2004 20:58:05 -0000

I chose Delimited.

I, also, could see no logic.

The Import Wizard allows a line at which to commence import.
Does it allow a line at which to end the import?

Perhaps then I could import the data in blocks which would
"fit" the column settings.

Is there an alternative to the Import Wizard?

Regards and Thanks.

"Frank Kabel" <frank.kabel@freenet.de> wrote in message
news:Or5a887$DHA.1732@TK2MSFTNGP12.phx.gbl...
> Hi Stuart
> IMHO the only way to correct this is playing with the text import
> settings. what setting did you choose?
> - fixed lenght
> - delimiters?
>
> Looking at you data examples there is no logic I can imagine to
> distinguish good/bad data.
>
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
> Stuart wrote:
> > The data is in the pdf file format, and the only way I know to import
> > this is via the Text Import wizard. That is how I set up the columns.
> >
> > It works for about 50% of the data........not the rest. There are
> > about 20,000 rows of data !!
> >
> > Some of the blocks of data do not align correctly with the result
> that
> > a column set for one block of data 'splits' data in another block
> >
> > eg: | 0.25 | 55 | is okay, but further down in another block
> > I'd get 0|.25 | 55 |
> >
> > Here's 'good' data:
> >
> > 10.25 153.78 1.2 85 and now 'bad'
> >
> > 8.75 158.99 78.34 5 doesn't align.
> >
> > Regards and thanks.
> >
> > "Frank Kabel" <frank.kabel@freenet.de> wrote in message
> > news:efF2Gz4$DHA.3284@TK2MSFTNGP09.phx.gbl...
> >> Hi Jason
> >> some questions:
> >> - How do you indentify a new column. That is why do you insert '125'
> >> and 'D' in column A.
> >> - Does the source data has a amximumn column number or how do you
> >> identify the last column (the last non-blank?)
> >>
> >> So you may explain the underlying algorithm for this with a little
> >> bit more detail :-)
> >> Otherwise this macro would be quite straightforward.
> >>
> >> --
> >> Regards
> >> Frank Kabel
> >> Frankfurt, Germany
> >>
> >> Stuart wrote:
> >>> After using the Text Import wizard, the bulk of the data is
> >>> in an acceptable format, but I'm left with this type of data,
> >>> split across columns:
> >>>
> >>> In A2: 126 Prices for Meas
> >>> B2: sured Work
> >>> C2: s - Major W
> >>> D2: orks
> >>> A3: D G
> >>> B3: ROUNDWORKS
> >>>
> >>> Corrected, the result is:
> >>>
> >>> A B
> >>> 2 126 Prices for Measured Works - Major Works
> >>> 3 D GROUNDWORKS
> >>>
> >>> I can locate these records using
> >>> If IsNumeric(Left(C.Value, 4)) Then
> >>> but I don't know how to proceed further.
> >>>
> >>> Any pointers would be much appreciated.
> >>>
> >>> Regards.
> >>>
> >>>
> >>> ---
> >>> Outgoing mail is certified Virus Free.
> >>> Checked by AVG anti-virus system (http://www.grisoft.com).
> >>> Version: 6.0.596 / Virus Database: 379 - Release Date: 26/02/2004
> >>
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.601 / Virus Database: 382 - Release Date: 29/02/2004
> 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.601 / Virus Database: 382 - Release Date: 29/02/2004

Relevant Pages

  • Re: Splitting/Combing data question
    ... The data is in the pdf file format, and the only way I know to import ... this is via the Text Import wizard. ... Regards and thanks. ... >> Outgoing mail is certified Virus Free. ...
    (microsoft.public.excel.programming)
  • Re: Encryption and File settings and transfer wizard
    ... Subject: RE: Encryption and 'File settings and transfer wizard' ... After I did the restore, ... looked for the .pst files and the folder was empty. ...
    (microsoft.public.windowsxp.security_admin)
  • RE: Problems with ISA2004 during SP1 upgrade
    ... Microsoft CSS Online Newsgroup Support ... | well until I got to the ISA 2004 portion. ... | "The wizard could not export your settings for the ISA 2000 Server. ...
    (microsoft.public.windows.server.sbs)
  • Re: Encryption and File settings and transfer wizard
    ... When using the wizard it first asks if this is the New computer or Old ... 'You can save files and settings to any disk drive or folder on your ... is a 40GB partition where my 'C' drive is a 10GB partition. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: WAY OT: Windoze admin help needed
    ... XP uses the file and transfer settings wizard, ... a floppy disk or a cdr ...
    (rec.motorcycles.dirt)