Input Edit

[tmumaw]

Hello all,

I have a file which I need to strip off a percentage.  The format can be 1/100% or 25/25% or 11/100%.  I only need the whole number at the beginning, but sometimes it can be 1 position and other times it can be 2 positions.  Any ideas?

Thanks

[fkeuroglian · Accepted solution]

Hi, you can use SUBFIELD function

subfield(Field, ';' ,2)

gives:

'cde' if Field is 'abc;cde;efg'

in you case:

subfield(Field, '/' ,1)

would return the first part before the first /

good luck

Fernando

[tmumaw]

Thank you Fernando.  That worked perfectly.  Have a great weekend.