 |  |  |  |  |  |  |  |
Match Strings using REFind
Please support our ColdFusion advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
I have a bunch of alphanumeric IDs for the data in my DB. The IDs may look like the foll:
0XAA001 or 1YBB010 or 2ZCC011 and so on.
Each of the 7 characters stands for something and therefore I have to extract the characters to populate the columns in the DB. I was able to use the REFind function (with the ^ special character) to grab the first 2 characters.
Extracting the subsequent characters is giving me trouble. What I want to do next is extract the 3rd and 4th characters (simultaneously) and do a comparison. Based on whether the pair is AA or BB etc, I have to populate a column in the DB.
How do I pull out the remaining characters - two at a time?
TIA!
0XAA001 or 1YBB010 or 2ZCC011 and so on.
Each of the 7 characters stands for something and therefore I have to extract the characters to populate the columns in the DB. I was able to use the REFind function (with the ^ special character) to grab the first 2 characters.
Extracting the subsequent characters is giving me trouble. What I want to do next is extract the 3rd and 4th characters (simultaneously) and do a comparison. Based on whether the pair is AA or BB etc, I have to populate a column in the DB.
How do I pull out the remaining characters - two at a time?
TIA!
 |
Similar Threads
- User Login (VB.NET)
- regex trouble (Perl)
- Replace sentence in perl (Perl)
- Search string array (C++)
- Help with lexical analyzer program (C++)
- Regular Expression (Perl)
- Identifying one set of strings from within a longer string (VB.NET)
- Searches only returning results for certain strings (PHP)
Other Threads in the ColdFusion Forum
- Previous Thread: Send a text message to your phone from your site!
- Next Thread: Mass-update table data with a single query?
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest ColdFusion Posts
- Today's Posts
- Unanswered Threads
