I have lots of data with disparate information in one field and I need to take all information to the right of any * that might appear into a separate field? There will be an * about 10% of the time.
Examples of the field in question.
CKD Stage I ****250.40/585.1
/Prosthesis Ca *185
So in the above two examples, I would want a separate field for 250.40/585.1 in the first example, and a separate field for 185 in the second example. The original field in the first would then be CKD State I and in the second example, the original field would be replaced with /Prosthesis Ca
December 4, 2008 4:21 PM
December 4, 2008 7:38 PM