Member Avatar for cheapterp

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!

  • 2 Contributors
  • 2 Replies
  • 148 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by cheapterp

Recommended Answers

All 2 Replies

Member Avatar for buddylee17

Why do you need regex for this? Can you not use basic string functions like LEFT, MID, and RIGHT?

Member Avatar for cheapterp

Thanks buddylee17,
I am not sure why I did not think of those functions! :-O

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.