LeftRight Function

[shredded]

I have two fields: Centimeters and Inches. I am trying to type in one (and vise versa), example (CM): 55-58 and then auto populate (IN) to 21.65-22.83. I was thinking using left or right function, but maybe there will be 3 or more digits in between the (-) symbol. What would be a good way to identify those digits in this case, so that I can apply the conversion vs script?

 

Thanks

[jbante]

Use substitute to convert the hyphen to a return, then you can get the different numbers with GetValue:

Let ( [
    _values = Substitute ( Table::field ; "-" ; ¶ ) ;
    _left = GetValue ( _values ; 1 ) ;
    _right = GetValue ( _values ; 2 ) ;
] ;
    /* ... */
)

[comment]

Ideally, you would have four fields: Min_cm, Max_cm, Min_in and Max_in, and they would all be Number fields.

To do it with only two (Text) fields, as shown in your example, you could make the IN field auto-enter a calculated value (replacing existing value) =

If (
Get ( ActiveFieldTableName ) & "::" & Get ( ActiveFieldName ) = GetFieldName ( Self ) ; Self ;
Let ( [
v =  Substitute ( CM ; "-" ; ¶ ) ;
min = GetValue ( v ; 1 ) / 2.54 ;
max = GetValue ( v ; 2 ) / 2.54
] ;
Round ( min ; 2 ) & "-" & Round ( max ; 2 )
)
)

and a similar formula for the CM field. No scripts are required for this.

This assumes there will always be two values in the source field, separated by a hyphen - otherwise more work will be required to prevent the result being displayed as "21.65-0".

 

Edited September 8, 2016 by comment