[shabbir]

There are quite a few string functions like
Asc
Format (with Strings)
Mid
Str
Chr
LCase
Replace
StrConv
Concat with & Left Right Trim
CurDir
Len
RTrim
UCase
Instr
LTrim
Space

Use them to split the string of your field.