Spliting one record into many

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a memo field with varying amounts of text in a semi-consistent format.
I need to split this text into multiple records based on a common delimeter
and then post to an access table. the delimiting text is a string of
multiple (50) "-" (hyphens).
I am restricted to using VBA,VBScript, Raw SQL and JavaScript for
development languages. No other tools available for this. Any suggestions?
I tried the SPLIT function but it would not take.
 
dracos_treasure said:
I have a memo field with varying amounts of text in a semi-consistent
format. I need to split this text into multiple records based on a
common delimeter and then post to an access table. the delimiting
text is a string of multiple (50) "-" (hyphens).
I am restricted to using VBA,VBScript, Raw SQL and JavaScript for
development languages. No other tools available for this. Any
suggestions? I tried the SPLIT function but it would not take.
Click to expand...
A hyphen is a bad delimeiter and Split only uses a single character.
You could use Replace to change the 50 hyphens to the pipe "|", a rarely
used character, then use split.
 
Thanks I will try that unfortunately I don't get to dictate the text it comes
from an automated source. Then again, if I replace the "-"(s) with a single
|, that may just solve the current error I am recieving. Will let you know
if it works.
 
Back
Top