A
AG
Hi All,
I am facing a challenge where I need to do certain computations based
on text that is entered by the users manually. There is a series of
cells in one column containing user narrative. In those narratives
users put a code, such as, "ABC" and their comment and also a date.
Please see the below examples:
ABC to be chased 03 SEP 09
To be analyzed ABC John 3SEP09
ABC Amended Ross 03/SEP/09
etc.
The date mentioned in the above cells can be anything and user enters
them in their own chosen formats as shown above. I need to count all
the cells that contain the text string "ABC" and a particular date, 03
SEP 09 in this case. The string ABC can appear anywhere in the cell
and the date can also appear anywhere. Plus the users choose their own
format to enter the dates.
One of the ways is to advise the users to enter the narrative in a pre-
defined format but right now I have a challenge where I need to
analyze 1000s of rows containing such narratives. Can anyone help me
on this?
I am facing a challenge where I need to do certain computations based
on text that is entered by the users manually. There is a series of
cells in one column containing user narrative. In those narratives
users put a code, such as, "ABC" and their comment and also a date.
Please see the below examples:
ABC to be chased 03 SEP 09
To be analyzed ABC John 3SEP09
ABC Amended Ross 03/SEP/09
etc.
The date mentioned in the above cells can be anything and user enters
them in their own chosen formats as shown above. I need to count all
the cells that contain the text string "ABC" and a particular date, 03
SEP 09 in this case. The string ABC can appear anywhere in the cell
and the date can also appear anywhere. Plus the users choose their own
format to enter the dates.
One of the ways is to advise the users to enter the narrative in a pre-
defined format but right now I have a challenge where I need to
analyze 1000s of rows containing such narratives. Can anyone help me
on this?