parsing data and making new columns with it by using as

[Bubskim]

i need to do the in between or sub field so that I can parse data

what is the best way to do this? 

[Lisa_P]

Can you give an example of what you are trying to separate ?

[Bubskim]

Yes.

For example I have a certain number of emails from email box 1 where the subjects are 'problem', 'critical', 'recovery', and 'warning' but they are all in one block so I need to create new "as" statements where I can put these in their own categories.