I need to write a Crystal formula that parses out the text from a field into discreet elements and I'm at my wits end. Basically the output from this field looks like:
[G]Good <F>Fair <P>Poor or
<1>`1T3 <4>`4T6 <7>`7T10 or
[N]None Seen <P>Eos Present
I need a formula that will strip out the "[]" and the "<>" parse out this field into something like:
Good
Fair
Poor or
1T3
4T6
7T10 or
None Seen
Eos Present
The number of elements can vary from 2 or 3 up to 10 or 11 and the delimeters can change from [] to <> to ().
Thanks for any help at all.
[G]Good <F>Fair <P>Poor or
<1>`1T3 <4>`4T6 <7>`7T10 or
[N]None Seen <P>Eos Present
I need a formula that will strip out the "[]" and the "<>" parse out this field into something like:
Good
Fair
Poor or
1T3
4T6
7T10 or
None Seen
Eos Present
The number of elements can vary from 2 or 3 up to 10 or 11 and the delimeters can change from [] to <> to ().
Thanks for any help at all.