> >I.E - i have a field that has a length of 241 i only need from character
> 48 to 70. ?
> >
> Use the SUBSTR function
>
> newValue = substr(this.value, 48, (70 - 48) )
> during save, replace the field with newValue
This will drop of one character.
Let's take a simple example. You want characters 2 and 3 from a 4
character string. So your expression is:
m.value = substr("1234",2,3-2)
therefore m.value = "2"
Your expression should have been:
m.value = substr("1234",2,(3-2)+1)
and then m.value = "23"
This is because you want to include the last item in the sequence that
you are looking for. You'll find the same is true with anything like
this, including dates and times.