distal-attribute
distal-attribute
distal-attribute
distal-attribute

New Feature Suggestion

User, date Message
Written by jamsession
4 years ago
Category: Feature discussion
120 posts since Sat, 22 Dec 07
I wish that the text editor had a search & replace utility; it would definitely speed up my work.

- j
Written by ansgar
4 years ago
5022 posts since Fri, 07 Apr 06
The query editor has that - but I guess you mean the grid-text editor?
Written by jamsession
4 years ago
120 posts since Sat, 22 Dec 07
I have a big database (almost 600 mb).

So, it would be easier to make the server find and replace unwanted text.

Yet, when I access data in a table, that particular text editor has various features, but not a search and replace.

- j
Written by ansgar
4 years ago
5022 posts since Fri, 07 Apr 06
You should help yourself with SQL:

UPDATE mytable SET col=REPLACE(col, from_str, to_str)

Written by jamsession
4 years ago
120 posts since Sat, 22 Dec 07
Thanks, but that wide-sweeping UPDATE command would miss slightly-different occurrences of the string needing replacement.

It would also replace those instances where the string being sought was, actually, part of an acceptable larger string. Or, when taken into proper context, was also acceptable. In these cases, I would not want to replace the string. For example, I do not want porn posted at my site. So, I would likely want to remove database lines which said something like: "You have permission to post porn here." To locate this type of string, I might search for "permission to".

Yet, I would probably not want to remove strings which said: "You do not have permission to post porn here." - despite that the search string "permission to" was present.

Similarly, I would probably not want to remove strings which were part of an interview and, so, were quotes - regardless of the search string being present.

So, prior to replacing, a visual check would be prudent.

So, this is when a dedicated search facility, in the text editor, would be handy.

Along a similar vein, a dedicated search facility would be handy where the data comprised of numerous paragraphs and the small string, which was being sought, was located somewhere among those paragraphs. So, it would be handy if the search facility highlighted all occurrences being sought.

- j
Written by jamsession
4 years ago
120 posts since Sat, 22 Dec 07
Here's another idea: How about incorporating the highlight feature, above, into the data tab's filter, too?

- j
Written by brunodasg
4 years ago
1 posts since Thu, 10 Feb 11

It would be interesting to implement shortcuts to the most used in the syntax editor.

Example 1:
When you type sf + space appear "SELECT * FROM".

Example 2:
When you type ii + space appear "INSERT INTO () VALUES ()".

thankful
 

Please login to leave a reply, or register at first.