Problem Deriving Two values from one field

[WHW]

Can I derive 2 values from the stated range:

Expected_S-T [0.085-0.250]?

When I use the text functions in separate calc fields, the Right(text, number) gives me problems...please see below....

Here's the problem: Left(Expected_S-T, 5) gives me the value .0850 which is acceptable, However....

Right(Exptected_S-T, 5) gives me the value WITHOUT the decimal point...(85025) and picks up the last 2 digits from the first value.

How can I get the value 0.085 in one field and 0.250 in another field--both originating from a single field?

Anything would be very helpful!

I can upload the file upon request.

Thanks,

Jon

[Lee Smith]

Jon,

You shouldn't use "-", or any other operator in your field names (FileMaker will give you a warning about this). I have changed your field name to Expected_ST and this field should be a Text Field.

Left Part a Calculation field, result Number

Left(Expected_ST, Position(Expected_ST, "-", 1, 1)-1)

Right Part a Calcution Field, result Number

Case(PatternCount(Expected_ST, "-") = 1, Right(Expected_ST, Length(Expected_ST) - Position(Expected_ST, "-", 1, 1)), PatternCount(Expected_ST, "-") >1, Middle(Expected_ST, Position(Expected_ST, "-", 1, 1) + 1, Position(Expected_ST, "-", 1, 2) - (Position(Expected_ST, "-", 1, 1) + 1)))

HTH

Lee

[WHW]

Lee, it worked like a charm. Are there any good tutorial files that will further expound on how the PositionFunction works? I'm a little puzzled with it.

Thanks again for the response, I appreciate it.