Parsing field up to first "-"

[#1]

Hi community,

I have a field made of two numbers seperated by a "-".  How would I parse it so that only the number before the dash is saved?

[CELAMBARASAN · Accepted solution]

Hi,

     Use SubField()

     SubField(FieldName,'-',1)

Celambarasan

[nilesh_gangurde]

Hi Brandon,

use subfield function at load time.

subfield(FieldName,'-',1)  as NewField,

Now this new Field contains the  numbers before the dash.

Regards,

Nilesh Gangurde