I have values in my query that looks like the following:
Decrease with an active address (2)
or Unsecured task (100)
etc.
The value within the parentheses varies, it can be one, two, three digits or more because this is a count value.
I just need to get the description not the parentheses nor the value. So what I need is just:
Decrease with an active address
Unsecured task
etc.
How can I get rid of the opening (
, the numeric value and the closing )
?
In ColdFusion 8?
As Dan mentioned in the comments, one option is using reReplace() with the appropriate expression to remove any text within parenthesis:
Update:
As Alex mentioned in the comments, if you just want to "cut" the string, and grab the part before the parenthesis, try something like this: