Hi,
Create the formula below
Local StringVar Str1 := ".";
Local StringVar Str2 := '73.2.700.710.U.BASE.F.I.5.6.5.2134.1.2' ;
Local NumberVar i ;
Local NumberVar c ;
For i := 1 to Len(str2) do
If Mid(str2, i, 1) = str1 Then
c:= c + 1;
while c <= 13 do
c:= c + 1;
Mid(str2,c);
or simpler version
Mid (str2,14,InstrRev(str2,'.'))
This will only work for records where the string is always same as the data posted.
'73.2.700.710. then U.BASE.F.I.5.6.5.2134.1.2
in the above case . before U is in 13th position
Cheers
Rahul
IP Logged
