How about this:
RightWords ( data ; 1 )
Jim
On Sep 13, 2008, at 9:24 AM, Stefan Garr wrote:
Hi
My knowledge of calc fields is limited. I need a calc that will
separate the last text in a field. I want to put that text in it's
own field. The text is always preceded by a space, which is the
last space in the field.
Here's an example of some of the data. So, in other words, I need
the dollar amount at the end of each line in it's own field.
08/02 Bill Pay 2145Minnenergy On−Line xxxx5916 On 08−02 56.59
08/02 Bill Pay 3126Minnenergy On−Line xxxx6817 On 08−02 47.24
08/03 Bill Pay macktruck Recurringxxx−xxxxxx0−000On 08−03
1,255.03
08/03 Bill Pay Wrights Smalleng On−Line Not Applicable On 08−03
248.60
08/07 Bill Pay 1201 8thavemort RECURRINGxxxxxx2966 On 08−07 543.88
08/07 Bill Pay 621 12th mortg RECURRINGxxxxxx3527 On 08−07 325.41
08/08 Bill Pay mort 423northern On−Line xxxxxx9522 On 08−08 919.71
08/08 Bill Pay Dallas Tire On−Line Not Applicable On 08−08 12.23
08/09 Bill Pay Kwik Trip On−Line x4659 On 08−09 2,462.53
08/09 Bill Pay GMAC 1631 4th RECURRINGxxxxxx6869 On 08−09 837.08
08/09 Bill Pay Mort 111 18thave RECURRINGxxxx6321 On 08−09 687.42
08/09 Bill Pay Emc 113 tenth RECURRINGxxxxxx4437 On 08−09 626.63
08/10 Bill Pay mort 423northern On−Line xxxxxx9522 On 08−10 919.71
08/10 Bill Pay 423 northern Rpu On−Line xxxxxxxx2532On 08−10
143.13
08/15 Bill Pay Oertli and Plesc On−Line Not Applicable On 08−15
175.00
08/16 Bill Pay Prius due 17th RECURRINGxxxxxx4054 On 08−16 578.62
Thanks in advance for any help you can offer!
Stefan
