Re: Splitting/Combing data question

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 03/01/04 

Date: Mon, 1 Mar 2004 23:24:44 +0100

Hi
no Acrobat Distiller is (unfortunately) no freeware. 

--
Regards
Frank Kabel
Frankfurt, Germany
Stuart wrote:
> I only have Acrobat Reader 6.0 (obviously FreeWare)
>
> Is Distiller freeware?
>
> This is hopefully a one-off import, so I'd rather avoid the
> purchase of new software.
>
> Regards.
>
> "Frank Kabel" <frank.kabel@freenet.de> wrote in message
> news:ezbbwH9$DHA.640@TK2MSFTNGP09.phx.gbl...
>> Hi Stuart
>> you said that the source file is a PDF document. Maybe you can use
>> Acrobat Distiller to export the PDF file to a different format and
>> use this file as import source.
>>
>> --
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>>
>> Stuart wrote:
>>> 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
>>
>
>
> ---
> 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