Extract Specific String ...

[#1]

Hi All,

1) I have a fied "Country" with values as

My output should be as follows

Appreciate help on this ...

[#2]

you can use subfield(Country, ' ',2)

[#3]

You can also use

=Right(Name,Len(Name)-8)

if they are all in the same format.

[#4]

With Name as your field name of course.

[MayilVahanan]

Hi

Try like this

subfield(Country, ' ',2)

[sujeetsingh]

Good replies

!!!!!