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>