Re: Autoformat Exec SQL

Thanks! I had the wrong slash.

That fixed it mostly. I was able to delete all the "spaces" and retype them to get it to stop.

Still weird

-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Daniel Gross
Sent: Wednesday, February 16, 2022 12:25 AM
To: Rational Developer for IBM i <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Autoformat Exec SQL

Don’t know if this helps, but the Regex for a tab char should be \t - if you are unsure about Regex syntax, you can try it out on

https://regex101.com/

This is what I always do, since I use Regex in SQL and RPG from time to time, and I’m always unsure about the syntax.

HTH
Daniel

Von meinem iPhone gesendet

Am 15.02.2022 um 22:10 schrieb Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>:

So the /t didn't find anything when I clicked on regular expression.

When I copied it to ACS, it looked the same but I could use my arrow left/right to see that tabs exist in the data.

CTRL-SHIFT-F formatted it correctly, but as soon as I clicked in a certain part of the expression, it shifted some of the lines again.

Not a big deal, just very weird.

-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Hiebert, Chris
Sent: Monday, February 7, 2022 11:22 AM
To: Rational Developer for IBM i <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Autoformat Exec SQL

In the RDI, open the find dialog and search for regular expression /t and replace that with a blank.

Chris Hiebert
Senior Programmer/Analyst
Disclaimer: Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.

From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Greg Wilburn
Sent: Friday, February 4, 2022 2:16 PM
To: Rational Developer for IBM i <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: [WDSCI-L] Autoformat Exec SQL


I recently pasted some SQL code into a source member. It must have contained a mix of tabs and spaces for the indents.

When I click different places in the code, I can see the indents "shift"... several lines move right.

If I click anywhere in the code section that moves, the rows "auto-align".



Can someone shed some light?

Greg Wilburn

--
This is the Rational Developer for IBM i (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/wdsci-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the Rational Developer for IBM i (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/wdsci-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com