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 · Accepted solution]

You can use SubField function here:

SubField(FieldName, '-', 1) as FieldName

[Peter_Cammaert]

=SubField(YourOriginalField, '-', 1)

[oknotsen]

= left(fieldname, (len(fieldname) - index(fieldname, '-'))

[sunny_talwar]

See this script:

Table:

LOAD *,

  SubField(FieldName, '-', 1) as Part1,

  SubField(FieldName, '-', 2) as Part2;

LOAD * Inline [

FieldName

1234-abc

13422-monday

136647536-tuesday

];

It's output:

[chrisg]

Hi Chintan,

try this:

left(Value,index(Value,'-')-1) AS Partleft

best regards

Christoph

[Anonymous]

Hello Sunny

Can I use this in front end report ?  I want something which can be user in report and not script.

Regards

Chintan Gala

[avinashelite]

Yes you can use in the front end also .

subfield(filed_name,'-',1) use this expression in the list box and charts

[Anonymous]

Thanks!

[Anonymous]

Good discussion thread here. Please be sure to mark helpful and correct answers.

Sara