Skip to Content
0
Former Member
Sep 30, 2009 at 10:28 PM

Pull Only Part of a Field up to a space

13 Views

Hello:

I promise I'm going to get better at this formula stuff, I'm just not very good with it at this point.

I have a description field in a report that the customer puts their own Change Request Number or Identifying number in the field first, with a space after, then types in the description of the change. I need to pull only that first number so I can insert it into the top of the form. For example, on this field:

AJFA4-09-257 NexGen Rearchitecture - Stand up the new infrastructure at ACT

I need to pull just that first number up to the space before the word "NexGen". I know there's a way to do this but for the life of me I can't remember how. Again, I'm sure there's a simple way but I'm stumped at the moment.

Thanks very much for all your help.

Barb