[AccessD] import text

Pedro,

If I have got the jist of what you want, I haven't had to find a solution
to something like this in a while I would write a little text file import
routine to read the text file line by line, you can use the
----------------- as the start/end of a record, then add the quotes and
semi-colons and remove the words CONCLUSIE and DIAGNOSES.

I am currently out of work so if you would like some help with the actual
code, just let me know.

Paul



On 15 April 2013 12:14, <pedro at plex.nl> wrote:

> Dear members,
>
> i would like the text-file below imported in Access.
> Problem is that the text isn't divided in one rule by record and there are
> no text delimiters.
> The text between the ---------------- must be imported into one record.
>
> At the first text line a "space" can be used as divider, then the word
> "CONCLUSIE" and DIAGNOSES.
>
> I would like the result as following (quotes and ; as separation by field)
>
> "**";"T02-00423";"14-01-02";"pn:";"01234567,";"gb:";"01-01-22";"m";"(91jr)";"aa";"naam-";"Biopt
> schouder ....";"huid*biopt*geen afwijkingen"
> "**";"T02-01350"; ......................etc etc
>
> Wo cab help me?
> Thanks
>
> Pedro Janssen
>
>
>
> <text_file>
>
>
> ----------------------------------------------------------------------------
>
> ** T02-00423 14-01-02 pn: 01234567, gb: 01-01-22 m (91jr) aa name-
>
> CONCLUSIE:
> Biopt schouder ....
>
> DIAGNOSES:
> huid*biopt*geen afwijkingen
>
>
> ----------------------------------------------------------------------------
>
> ** T02-01350 06-02-02 pn: 07654321, gb: 01-01-68 v (33jr) A.W.G.J.
> name2-name3
>
> CONCLUSIE:
> Huidexcisie linker ......
>
> DIAGNOSES:
> huid*excisie*melanoom
>
>
> </text_file>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com