String Manipulation

[victora]

Good morning to all,

I have a portion of a text field that I need to include on a letter but its a little tricky(at least on my part). Heres the narrative:

Our claim Dept enters an explanation of why they are denying a claim on a field that was initially intended for another use; they enter a "*" prior to the denial reason. Now I have to grab that text after the "*" and include it in a letter.
---
Example of a Note entry:
This is a claim from electronic load. Date added: mm/dd/yy
*The reason for this denial is blah, blah, blah...
You can contact us at 1-800-123-1234...

----
How do I concat/parse/split the field so to get that chunk of text after *

Thanks
victora

 

[lbass]

You should be able to use a formula like this:

if instr({table.field},"*") > 0 then
mid({table.field},instr({table.field},"*"))+1

-LB

 

[lbass]

Sorry, that should have been:

if instr({table.field},"*") > 0 then
mid({table.field},instr({table.field},"*")+1)

-LB

 

[victora]

thanks lbass, it worked like a charm! I can't thank you enough. As usual, you're the expert. I have in my file solutions you've extended to me all these years.

Again, thank you!