Text to excel
11/24/2014 1914 views
Hey IT folks!
Hope you can help me with a rather messy text file that I am trying to import to excel..
The text file looks like this:
Technique: AP, lateral and oblique views
FINDINGS: There is no evidence of acute fracture or dislocation. There is lateral soft tissue swelling seen. No evidence of any bone destruction.
IMPRESSION: Soft tissue swelling but no evidence of obvious acute fracture is demonstrated.
INDICATIONS: <<Clinical Information>>
COMPARISON: [< None. >]
FINDINGS: [ ]
I would like it to go into excel as this
|ankle swelling||Technique:||AP, lateral and oblique views|
|ankle swelling||FINDINGS:||There is no evidence of acute fracture or dislocation. There is lateral soft tissue swelling seen.|
|COMPARISON:||[< None. >]|
the only things that are consistent that would identify each column are:
- The start of new title (columnA) is immediately after $$$ this indicates start of new record
- Each of the sub titles (columnB) ends in ":"
- Each of the descriptions (columnC) starts after the ":"
Any one has any ideas? VBA script maybe? but i wouldn't know where to begin!
Thanks in advance.
Be the first to answer this question