Regular Expression to read the first three characters of an 11 character field
G
Gemma Pearce
started a topic
almost 7 years ago
Hi Chaps
We are running IOM version 2.7.1.6 (I know this is an older version, but we haven’t had time to upgrade as yet).
My question is this. I have a field with 11 characters in it. It would be great if I could get a regular expression to read the first three characters of the field and use it to dictionary the fund the gift is to go towards.
For example reference TGJ00001123 to go to fund 12050, but reference WSH00001123 to go to fund 13664.
Is this possible? I have looked online, however this is way outside my field of knowledge, and I am not sure I even understood the answers, so basic step by step instructions would be really appreciated!
From there, is there a way to get regex to read the first two numbers of a date field and use them in a virtual field? Or is that ridiculously complicated?
Gemma Pearce
Hi Chaps
We are running IOM version 2.7.1.6 (I know this is an older version, but we haven’t had time to upgrade as yet).
My question is this. I have a field with 11 characters in it. It would be great if I could get a regular expression to read the first three characters of the field and use it to dictionary the fund the gift is to go towards.
For example reference TGJ00001123 to go to fund 12050, but reference WSH00001123 to go to fund 13664.
Is this possible? I have looked online, however this is way outside my field of knowledge, and I am not sure I even understood the answers, so basic step by step instructions would be really appreciated!
From there, is there a way to get regex to read the first two numbers of a date field and use them in a virtual field? Or is that ridiculously complicated?
Many thanks
Gemma