which function I can use?

[#1]

Hello All

I have a field with values like below

1234-abc

13422-monday

136647536-tuesday

I need to display only the part before '-' 

eg) 1234  ,  13422,  136647536.

Kindly help me what function I can use to get above result.

Thanks in advance...

[sunny_talwar]

Can you share your script? so that we can see what exactly are you doing?

[SreeniJD]

Left, Right, SubField, KeepChar all of these functions are available. And there wouldn't be major performance issues among these functions. Please suit yourself!

HTH

Sreeni

[avinashelite]

see if you want to show this in the list box go list box properties >General>Feild>click on the down arrow here you have the option to add expression > subfield(filed_name,'-',1) this will give you the result in the list box.

If you want to use it in the chart go to>chart properties>dimensions> add calculated dimension > add the same expression

[Anonymous]

Many Thanks .. It worked ..

[oknotsen]

Sara,

She could not do that as apparently I approved a topic being made by a guest post.

I flagged a correct answer, which should solve this.