hi all, recently ran into a really hard problem for me:
i have an sql command with something like this
SELECT xxxxx FROM xxxxxx WHERE filter LIKE '[A]'
what i would like to do is substitute [ with [ on the condition that it is after a LIKE and is within " ' " and " ' " directly after the like. regex comes to mind, but i really don't know how to start.
i obviously can't use string.replace because there's that condition that i need to meet.
what i would like to specify is that when i find a LIKE operator, look for two " ' ", if they are found, look between them to find [, if it is found, replace it with [.
will this be possible? or can someone suggest a brighter idea.