John86a
asked on
How can I grab sections of a text file ?
Hi, supposing I generate a text file with the following template:
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.:
Thanks.
SOME
MULTI
LINE
CONTENT
£
ANOTHER
MULTI
LINE
CONTENT
£
YET
ANOTHER
£
AND
ONE
MORE
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..
Thanks.
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
systan
glad to see you again epasquier =)
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Until this question, I'd never thought that there could be confusion between the pound keyboard character and the British currency pound symbol.
Makes my head pound. (I'm sure there's a symbol for that too)
=======
@John86a
The British currency symbol may be rare, but it is used frequently in some parts of the world.
Makes my head pound. (I'm sure there's a symbol for that too)
=======
@John86a
The British currency symbol may be rare, but it is used frequently in some parts of the world.
ASKER
@aikimark I'll have you know that I've lived in London for quite a few years, and yes, I'm well acquainted with the currency pound. However, you should also consider that it's not called pound everywhere in the world, and that your comment was nothing but futile and wholly derailed from the topic objective.
Some countries - like the one where I'm from, calls the British currency 'Libra Sterling'. I guess you wouldn't know that, since you're evidently caved in.
Some countries - like the one where I'm from, calls the British currency 'Libra Sterling'. I guess you wouldn't know that, since you're evidently caved in.
ASKER
Thanks guys.
@John86a
>>...like the one where I'm from...
You registered with EE from a Brazilian IP address. Is that the country that uses Libra instead of Pound to refer to UK currency?
>>...caved in
With the wealth of information available on the 'Web, I'm not sure I could classify myself as caved in even if I never left the house. My posted comment was referring to your "unique and unlikely to be used in SQL" assertion. I had no idea what country you were in or from when I wrote that.
The most common reference in the world, certainly in the financial world and in foreign-exchange markets, seems to be Pound Sterling. My comment was meant to contribute to the resiliency of your application/database, not to denigrate you in any way.
You're welcome.
>>...like the one where I'm from...
You registered with EE from a Brazilian IP address. Is that the country that uses Libra instead of Pound to refer to UK currency?
>>...caved in
With the wealth of information available on the 'Web, I'm not sure I could classify myself as caved in even if I never left the house. My posted comment was referring to your "unique and unlikely to be used in SQL" assertion. I had no idea what country you were in or from when I wrote that.
The most common reference in the world, certainly in the financial world and in foreign-exchange markets, seems to be Pound Sterling. My comment was meant to contribute to the resiliency of your application/database, not to denigrate you in any way.
You're welcome.
Delphi
Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.
60K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
