AlexPonnath
asked on
Need help with a regular expression
i need to parse some text and replace some stuff and i think regular expressions is the best way to go.
i need to find the following strings
A) ",, , ," which is a comma + comma = space + comma + space = Comma
B) ",,|"
c) "2014-06-17 13:00:42,, , ," the date could always change
also is there a quick way to find with regular expression the following scenario wher there is always a 4 CHAR string
followed by 2 commas and i would like to change it to string and 1 comma like from "MB01,," to "MB01,"
i need to find the following strings
A) ",, , ," which is a comma + comma = space + comma + space = Comma
B) ",,|"
c) "2014-06-17 13:00:42,, , ," the date could always change
also is there a quick way to find with regular expression the following scenario wher there is always a 4 CHAR string
followed by 2 commas and i would like to change it to string and 1 comma like from "MB01,," to "MB01,"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ColdFusion doesn't use pattern delimiters, so you can drop the forward slashes ( / ) from ozo's suggestions. If Javascript is in use, then you will need to keep them.
aikimark -- zone advisor