RUA Volunteer2?
asked on
Is there a Crystal Reports formula that takes out RTF formatting embedded in a field
I have a field that has RTF embedded inside of the field all around the text I need. Does Crystal Reports have a tool that removes that formatting by chance? The word "Test" in front of "\par" is what I need to get out of the field. Each field is a bit different.
{\rtf1\ansi\ansicpg1252\de ff0\deflan g1033{\fon ttbl{\f0\f nil\fchars et0 Microsoft Sans Serif;}}
\viewkind4\uc1\pard\f0\fs1 7 Test\par
}
Another example below we need the record the words "I wish I was in the land of cotton."
{\rtf1\ansi\ansicpg1252\de ff0\deflan g1033{\fon ttbl{\f0\f nil\fchars et0 Microsoft Sans Serif;}}
\viewkind4\uc1\pard\f0\fs1 7 I wish I was in the land of cotton.\par
}
I just wondered if Crystal had such a tool that recognized RTF and could remove it and just show text?
{\rtf1\ansi\ansicpg1252\de
\viewkind4\uc1\pard\f0\fs1
}
Another example below we need the record the words "I wish I was in the land of cotton."
{\rtf1\ansi\ansicpg1252\de
\viewkind4\uc1\pard\f0\fs1
}
I just wondered if Crystal had such a tool that recognized RTF and could remove it and just show text?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I had forgotten that one was in there. That was a training question 3 years ago. I remember it now. I wondered if you could but I thought it was a formula function and could not find it thank you all very much.
ASKER
2) What is producing the report? When you say producing do you mean the application? It comes out of an ACT database. It has an OLE DB driver that pulls the data out.
3) Do you have the latest patches for Crystal Reports Yes we have the latest patches.
See the image below. There is a little more to the records than that. They are not always consistent. How do we drop the RTF formatting embedded in the field.I do not know if this helps.
HistoryDetailsField.png