Hi PepsiHog, Interesting... First, here's the answer: let>Number=22 let>Data=01:02;10:22;08:32;44:52;10:22; MDL>Data Let>pattern=((\d\d:%Number%)|(%Number%:\d\d));(.*) RegEx>pattern,Data,0,match,nm,1,$4,Data MDL>Data The above will work whether Number = 10 or 22 or any two digits in your data. It te...

Hi PepsiHog,

Only have the Blackberry at the moment. Please just post an example of your data string and what you want to do to it and I'll take a look later tonight... Not a problem.

Hoping someone can tell me how to do this. I have a RegEx looking for one pattern or another. But I only want the first instance to be removed, not the second. (if there even is a second) Sure thing - here's how I would do that: let>Number=10 let>Data=01:02;10:22;08:32;44:52;10:22; MDL>Data Let>pat...

jpuziano, thank you for your help. I hadn't run into the RegEx function before, but I certainly won't forget it now! Well glad I could help! Yes Regular Expressions are quite amazing... I encourage anyone reading this to experiment with the RegEx> command. Also, you used this: Let>pattern= [ \x00 ]...

Hi malvern, You are simply running into the concept of the null-terminated string. http://en.wikipedia.org/wiki/Null-terminated_string i.e. the first Null it runs into (hex 00) it thinks it has reached the end of the string and does not display anything beyond that. The easiest would be just to use ...

Yes a few tenths of a second may not matter but who knows what would happen with a much larger recordset. It is good to know about both methods. Results with 100k and 1 million patients. Total Patients: 100,000 JP's method Time to Process = 0.037 JRL's method Time to Process = 0.45 Total Patients: ...

Hi kpassaur, Great looks like DBQuery is the way to go! Not sure why you'd conclude that :? because according to JRL's timings... my method is from 4 to 20 times faster than DBQuery. Also now just saw JRL's second post... Yes a few tenths of a second may not matter but who knows what would happen wi...

Hi kpassaur, 40 seconds huh... ouch. Here's some thoughts for faster record retrieval: - Read all the data into a single variable using ReadFile> - Then use a RegEx command to locate the record you want by matching the patient number and also match all non CRLF chars after that which will get you ev...

Hi olllllliii and JRL, The ability to auto-size column width and/or height in a StringGrid object based on the data loaded would be a great feature even if its something we'd have to code ourselves. A little Googling found the link below and even though its Delphi code, perhaps it will be helpful: ....

Re both questions I will need to ask the developers of the editing component. I have no idea what the template thing is either. I will also need to refer back to the syntax editor developers. OK, thanks for the reply. Please let us know when you find out more. Maybe that template thing is something...

REGEX Rocks eh. Indeed it does Phil... :D indeed it does. Q1) Marcus, can the Replace field be enhanced so that it does understand a backreference when Options/Regular expressions is checked? Q2) Marcus or anyone - In the Search/Replace Dialog, under Options, there is a checkbox called "Replace wit...

Hi andrewbarbour, It seems to work because yes... the % chars around %strLine% mean that the comma ' chars within your string are no longer being confused as parameter separators in the Position> command... however you said... I am looking to find the position of the "close bracket comma space" i.e....

Hi JRL, Cool script... here's the results for my MS 12 install: 200 of 475 files contain a total of 1905 instances of "" I haven't seen an instance of not working either... however if anyone out there can come up with such an example, I heartily encourage you to post it. I am all for fixing bugs if ...

Hi BrianM and JRL, You also have to watch out for the special properties of the Ampersand & char when creating Label text in dialogs... and with label text you place on a Button in a dialog and other objects... its just a Windows thing. In Microsoft Windows menus, labels and other captions, the ampe...

Hi JRL, Thank you very much for posting the above script. After I commented out the reset message you were popping up, I did get it working. Then I was thinking that on a faster PC, a person would have to adjust those counter values to properly detect the double left click and I wanted a method that...