[AccessD] import text

pedro at plex.nl pedro at plex.nl
Mon Apr 15 11:14:38 CDT 2013


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>


More information about the AccessD mailing list