How to write a formula to get position names in the middle of string

[Rbp1226]

Hi,
I am using Crystal Version 2008 against Oracle 10g database
There is a column in database - Position Name

Example:
Y1928.IT SPECIALIST (APPSW).1987452.ARSE.APPR
218168.INFORMATION TECHNOLOGY SPECIALIST.992467.ARSE.APPR

I only want the real name in the middle:

IT SPECIALIST (APPSW)
INFORMATION TECHNOLOGY SPECIALIST

Want get out of before dot in the beginning and after dot in the last few.

Anyone have good idea? Thanks!

 

[fisheromacse]

Something like this:


SPLIT({Table.Field},".")[2]


This is off the top of my head, so apologies in advance for typos/mental errors.

 

[Rbp1226]

fisheromacse,

It works fine. Thanks!

Rbp