regarding validation

[veera24]

hi all,
one of my column values containin hyphen(-) in it.
for ex the input seems like 1200-12,563467-093,3789652-02.
In this scenario am in need of the value before the hyphen only and meanwhile the number of digits before the hyphen will greatly vary.Can any one help me to how to get the required value?

Thanks in advance,
veera.

[chulett]

Why post this twice? Delete the other post before people reply to it, please.

The Field function will do the job for you, check the online help.

Code: Select all

Field(YourData,"-",1,1)