troubleshooting Question

How can I grab sections of a text file ?

Avatar of John86a
John86a asked on
PascalDelphiProgramming Languages-Other
8 Comments3 Solutions521 ViewsLast Modified:
Hi, supposing I generate a text file with the following template:

SOME  
MULTI
LINE
CONTENT
£
ANOTHER
MULTI
LINE
CONTENT
£
YET
ANOTHER
£
AND
ONE
MORE

Open in new window



Seeing that the content is separated by Libra sign (since it's unique and unlikely to be used in SQL), how can I programatically grab each section and  paste it into sql queries?
I.e.:
query.SQL.ADD(Section1); 
query.ExecSQL;
query.SQL.Clear;
Query.SQL.ADD(Section2);
query.ExecSQL;
query.SQL.Clear;

and so on..

Open in new window


Thanks.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros