Changing the case of all text except the ones within single

[manualph]

Posted this in forums.
http://forums.textpad.com/viewtopic.php?t=10818

I guess there isn't a straightforward way to do this using textpad. Hence posting this as an enhancement request.

Version 5.3.1

I want to convert codes like below to lower case (Ctrl+L) in one go. But i want to retain the case of the strings within single quotes

Code: Select all

SELECT DOB_DT
					INTO V_POT_J
					FROM EMP_DTL
					WHERE EMP_CAT_CODE_C = 'CONFIRMED'
					AND TRAN_TYPE_C = 'BONUS'
					AND EMP_ID_C = V_EMP_ID
					AND EMP_DEP_J = 'Y'
					AND DOB_DT <= V_YEAR_END_DT;
			EXCEPTION
			WHEN NO_DATA_FOUND THEN 

There should be feature like 'Case Changer' with options to preserve the case within single quotes/double quotes/some condition.

[ak47wong]

You couldn't wait a day for an answer?

[Art Metzer]

Or search?

[manualph]

Ben Josephs provided a workaround for this.
http://forums.textpad.com/viewtopic.php?p=36272#36272

But , i still think there should be a similair feature for users like me who are not good at Regular expressions.