J
Jason K
Hi,
I have a field that can contain two differnt variations.
Let's say the field (infoview) contains
WN1401S.C05344.MV01000.P00208 then the below logic works
fine to get 1401 out of the first node.
strFromLeftOfC = Left([infoview],InStr(1,[infoview],".")-1)
strAC = Left([infoview],2),
strNumber = Mid([infoview],3,4);
My question is, is there another query I can write to get
9222 & 1409 from below? Or can it be combined with the
above somehow?
Basically, if the letter after the first period starts
with anything but C then I need characters 2-5 if not I
need 3-6
T9222TT.P182
P1409WM.OUTL70.W1209
Thanks.
Jason
I have a field that can contain two differnt variations.
Let's say the field (infoview) contains
WN1401S.C05344.MV01000.P00208 then the below logic works
fine to get 1401 out of the first node.
strFromLeftOfC = Left([infoview],InStr(1,[infoview],".")-1)
strAC = Left([infoview],2),
strNumber = Mid([infoview],3,4);
My question is, is there another query I can write to get
9222 & 1409 from below? Or can it be combined with the
above somehow?
Basically, if the letter after the first period starts
with anything but C then I need characters 2-5 if not I
need 3-6
T9222TT.P182
P1409WM.OUTL70.W1209
Thanks.
Jason