how to Extract the date or text from the whole column

[Arun.fpg]

I want to extract the text or date from the whole column like more than 1136
column. ineed to extarct the a single word like Verify or Clarify from a
sentence in the column

Thanks

Regards

Arunkumar

 

[Jacob Skaria]

Would you be able to provide few examples..

 

[Arun.fpg]

Order has already been entered for dos 01/02/09,02/04/09,0310/09-04/07/09
Dt not recvd for this patient. Hence order & rx not created.
Dt recvd for 09/23/08 dos. Since system date is 09/29/08. Order & rx not
created.
Dt recvd for 02/07/08 dos. Since system date is 02/08/08. Order & rx not
created.
Dt recvd for 03/11/09 dos. Since system date is 03/12/09. Order & rx
entered. Product given as "Conc" & "a/s vision air". Hence took product as
E1390 and "Airstep free style". Please clarify whether correct action has
been taken or not. Hence order & rx not confimed.
Dt recvd for 11/20/08 dos. Since system date is 11/25/08. Order & rx not
created.
Dt recvd for 11/04/08 dos. Since system date is 11/5/08. Order & rx not
created.
Dt recvd for 12/19/08 dos. Since system date is 12/22/08. Order & rx not
created.
Dt recvd for 2/07/08 dos. Since system date is 02/08/08. Order & rx not
created.
Dt recvd for 08/01/08 dos. Since system date is 08/08/08. Order & rx not
created.
"1) Dt recvd for dos 01/09/09. Order has already been confirmed for this dt.
Hence order & rx not created.
2) Dt recvd for 02/04/09. Order has already been confirmed for this dt.
Hence order & rx not created. However product ""swivel connector"" is not
found in the entered Dt. Please clarify.
3) Recvd dt for 03/04/09,Since product is E-tank order & rx not created.
4) Entered dt for 03/11/09 dos. For ""conc"" took as ""E1390"". Please
clarify. Hence order & rx not confirmed.Since system date is 03/04/09.
4) Recvd dt for 04/01/09 dos. Since system date is 04/06/09. As well as
product is M-6.Hence order & rx not entered."
Dt recvd for 04/04/08 dos. Since system date is 04/07/08. Order & rx not
entered.
Dt recvd for 12/16/08 dos. Since system date is 12/16/08. Order & rx not
entered.
Recvd dt for 01/05/08 dos. System date is 01/05/09. Kindly clarify whether
we can enter the order or not.2) Recvd dt for 02/04/09, sicne products are E&
M-6 tank. Order & rx not entered.
Recvd dt for 06/24/08 dos. Since system date is 06/24/08. Hence order & rx
not created.
Recvd dt for 02/06/09 dos. Not sure of the products. Need
clarification.Hence order & rx not entered.
"Recvd dt for 01/29/09 dos. Order and rx entered. Please clarify whether
correct action has been taken or not. Hence order & rx not confirmed. Cmn not
confirmed.
2) Order has already been entered for dos 03/10/09."
Product is not clear. Hence order & rx not entered. Please clarify.
Order and rx entered for dt 01/06/09 dos. Please clarify whether correct
action has been taken or not. Hence order and rx not confirmed as well form#
taken as 0. Cmn not recvd. Hence cmn not confirmed.
Order and rx entered for dt 01/29/09 dos. Order confirmed. Cmn not recvd.
Hence cmn not confirmed.
Dt recvd for 07/02/08 dos. Since system date is 07/03/08. Hence order & rx
not entered.


By this example i need extract the exact word or separate the exact word
like NOT CREATED. Can you please explain