on 01-25-2015 6:04 PM
Hi,
My field is having A1234.1
Required o/p is A1234
I need all characters till '.'
Could you please help me how to off set this.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
word_ext('A1234.1',1,'.') .
Refer the technical manual
You can use the word_ext function:
word_ext('A1234.1',1,'.')-----> o/p A1234
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.