2

I'm programming in Eclipse and i have a SQL script that got multiple lines:

SELECT * FROM
.... (bla bla)
... (bla bla )..
... (bla bla bla bla)

I have to add the double quotes like this:

" SELECT * FROM "
+ ".... (bla bla) "
+ "... (bla bla ).."
+ "... (bla bla bla bla) "

Is there any SHORTCUT to do this in Eclipse?

EDITED:

I have a SQL script that got like 50 lines (for examp.):

line 1: SELECT * FROM 
line 2: HR_EMPLOYEES
line 3: ... (bla bla)
.
.
.
line 50: AND NAME like 'AP%'

I have to do in every line this:

+ " (CODE SQL) "
+ " (CODE SQL) "

MANUALLY.

Is there any shortcut to do this ( + " " ) in eclipse java language?

Jhonatan Sandoval
  • 1,283
  • 6
  • 24
  • 40
  • @rec I do not agree, the string is already split. – Jagger Sep 10 '13 at 22:06
  • @Jagger good point... but I have an idea then ;) Thanks for pointing that out. – rec Sep 10 '13 at 22:09
  • I don't know of an Eclipse shortcut for this, but Sublime Text offers a very convenient way of multiple edit. Depending on platform either use Ctrl or cmd to multiple edit. – arin Sep 11 '13 at 20:14

5 Answers5

2

Use column selection Alt + Shift + A and then select the "beginnings" of the lines and simply type + " then do the same for the end of lines but type ". This will insert typed characters in all of the selected lines.

I attach a short video on how I do it in Eclipse.

Jagger
  • 10,350
  • 9
  • 51
  • 93
0

You can type it out in one line like

"SELECT * FROM blah .... (bla bla) .... (bla bla) .... (bla bla bla)"

And then put your cursor where you want to begin on the next line, hit enter, and Eclipse will automatically add the respective ""s and +s

Or as you are typing out the query string, just hit enter when you want to go to the next line. If you are typing a string (with quotes) it will automatically add the "" and +s

Or if you are copying and pasting the query string try this out https://stackoverflow.com/a/2159931/2386700

Community
  • 1
  • 1
Adam Bullock
  • 109
  • 3
  • -1 because this does not provide the answer to the question. The string is not a long line. It is already split. – Jagger Sep 10 '13 at 22:10
0

Could you please specify the programming language you're using?

Assuming you meant java, I'd say just use the String class method called "replace"

And you will need to replace the "new line" char (\n) into " \n + ".

Hope this will help you create your solution.

Jacob Cohen
  • 1,232
  • 3
  • 13
  • 33
0

So you have this situation

some text
some text

and want to arrive at

"some text"
+ "some text"

The easiest I can imagine is this: replace linebreaks with "(linebreak)+ "

1) write this somewhere

"
+ "

2) mark that from " to " text and copy it

3) open the search/replace dialog

4) paste to the "replace with" field (yes, you can paste strings with new lines there)

5) write a newline somewhere, basically a line and press "enter" immediately

6) mark this line break (start mark in first position in a the first line and end in the first position of the next line)

7) cut and past into the "find" field (mind that nothing will appear there!)

8) mark all the text you want to fix up

9) select scope: selected lines

10) replace all

11) add extra " in the first line and remove extra +" in the last line

"some text"
+ "some text"

Shortcut? Well, if you have many lines to fix up... yes, it can make a difference.

rec
  • 10,340
  • 3
  • 29
  • 43
0
  1. Simply define a String in Eclipse like private final String selSQL="";
  2. Copy-paste your query between the double quotes
  3. Press Enter key at any end of word, the eclipse automatically appends double quotes "", followed by concatinator + on the same line, and double quotes " in the next line for the continuation.
  4. Use Del and End to continue for the rest, until all lines are concatinated.
user3335966
  • 2,673
  • 4
  • 30
  • 33
Sreerang
  • 1
  • 1