Community

Posted: **Wed Oct 13, 2010 7:54 am**

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.

Posted: **Wed Oct 13, 2010 12:55 pm**

You couldn't wait a day for an answer?

Posted: **Fri Oct 15, 2010 3:34 pm**

Or search?

Posted: **Mon Nov 01, 2010 1:02 pm**

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.

Community

Changing the case of all text except the ones within single

Changing the case of all text except the ones within single