-
March 6th, 2014, 03:52 PM
#1
Help in stripping data from a field
I am trying to remove some data from the field below:
<p style="font size:12px;color:Red"><b><u>High Risk:</u></b> Includes critical care, hip, pelvis, & knee surgery requiring general anesthesia>30min., spinal cord injury, cancer surgery, major trauma, pts w/ adverse individual risk factors, or HX of VTE.
I have no problems getting the <b>, <u>, </b>, and </u> removed but can not seem to get the "<p style="font size:12px;color:Red">" out.
I need to be able to look for it no matter where it might be in the text string, and I was just going to do a replace with blank.
I have tried several different things and the problem I am having is that the variable for the start position and the length contain decimals. I have tried doing the following as well to get rid of the .00 in the NumVar and it doesn't like the StringVar, it wants a whole number.
NumVar MyStartVar := Instr({@FieldName}, "<p")
NumVar MyEndVar := Instr({@FieldName}, ">")
NumVar MyLengthVar := (MyEndVar + 1) - MyStartVar
StringVar MyStartVarS := CStr(Round(MyStartVar),"#")
StringVar MyLengthVarS := Cstr(Round(MyLenghtVar),"#")
Replace(Mid({@FieldName},MyStartVars,MyLengthVarS),"")
I also tried converting the StringVar with CDbl and it put the .00 back. I really need to get rid of those decimals.
I hope that someone with a lot more knowledge than I can help me to solve this editing issue so that I can get this very much needed report done.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|