Parsing numbers from within text

[Margaret]

In a table named FollowUps, in a Column named FollowUpAction, I have values that usually look like this

"Other action taken 9322 Counseled Appropriately"

When they look like that (Other action taken #### [further text], where [further text] is a few words that vary), I need to parse out the 4 digit number (always 4 digits) and the text after the 4 digit number into two different columns.

1) How do I do that?

2) How would I figure similar function/coding questions out if I didn't have this forum or needed an answer asap?

Thanks so much!

[Margaret]

Hah! I got it!

I thought I was doing what you said. But since I did this:

     [Followup Immediate Action(s) Taken] as ActionTaken,

I thought I could use "Action Taken" as the new name of the field. But I guess it doesn't get renamed until the whole script loads?

Thank you SOOOO much for your persistence and assistance!!!!!

[Margaret]

I didn't completely try this but thank you for taking the time to try to help me!

[sunny_talwar]

Not a problem

I am glad I was able to help