Using "StripString" in CR 10

[Seabz420]

Do I need to use the add in UFLTECH1.exe? The Business Objects says to use it up to version 7.0...I'm using 10. When I run the report in 10, I get an error on this line:

StripString ({pages_tab.IP ADDRESS},{@IP Address Strip} )

Ideas?

 

[bdreed35]

You might try using the Replace function instead.

For instance, if yo wnated to remove all hyphens out of a SSN field you could do it this way:

Replace({table.SSN},"-","")

Use the above logic in your formula instead of StripString.

~Brian

 

[bdreed35]

Here is your example with the Replace function:

Replace({pages_tab.IP ADDRESS},{@IP Address Strip},"")


~Brian

 

[synapsevampire]

Hopefully Brian nailed it, replace probably does the same job, but if not, try posting specific information.

"When I run the report in 10, I get an error on this line:

StripString ({pages_tab.IP ADDRESS},{@IP Address Strip} )"

What error did you get?

What's in the referenced formula {@IP Address Strip}?

Why not take the extra 30 seconds to post the specifc error message and the code you used?

-k

 

[Seabz420]

The problem is that the table isn't setup properly. I'm working on a report that is someone else's and no-one really knows where the table is that it references. When I checked, that table is not there! Once I get that figured out and tested, I'll post if the problem is still occuring..but i doubt it.

 

[Seabz420]

I ended up putting the UFLTECH1.exe file on my system which allowed the above function to work.