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.
regarding validation
Moderators: chulett, rschirm, roy
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.
The Field function will do the job for you, check the online help.
Code: Select all
Field(YourData,"-",1,1)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers