New Feature Suggestion
| User, date | Message |
|---|---|
|
Written by jamsession
2 years ago Category: Feature discussion 113 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
2 years ago 4027 posts since Fri, 07 Apr 06 |
The query editor has that - but I guess you mean the grid-text editor? |
|
Written by jamsession
2 years ago 113 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
2 years ago 4027 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
2 years ago 113 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
2 years ago 113 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
2 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. |