>can someone please help me with this. I have a character string in which I am trying to get rid of spaces. I know it is transform() but setting it up is hit and miss. just the data between the brackets. in first example the space before 40 needs to be eliminated. the second example is correct.
>
>this is the text I need clean -> periods[ 40-41] just the area within the brackets.
>this text is properly formatted -> periods[50-51]
>
>the text is stored into a field called rinfo
>
>
>tnx for your help
>k

REDUCE() in foxtools.