Searching and editing links in Notes

[shimon]

Hi,
We used (part of the) notes on elements to link to documents. As the directory name of some of these documents were in Hebrew, these hyperlinks do not render properly ( and do not work) in any RTF Documentation.

The work-around that seems to work is to create a file in a directory who's path is only in English that links to the original file.

The problem is to find all these links. The capability of viewing the present path  for a hyperlink in the Notes is non-existent in EA.

Using the SQL to search the Notes did not bring any results as explained by Geert here:
https://sparxsystems.com/forums/smf/index.php/topic,47483.msg276791.html#msg276791.

After figuring this out (and giving the Notes column an alias) I have to figure out the syntax for striping the Notes and leaving only the Hyperlinks.
Another option is to find non-English characters in a Hyperlink.

Sincerely,
Shimon

P.S. If anyone has done this already, please share.



 

[Geert Bellekens]

I think the best option is to create a small script to update your notes.

If you have a list of before/after paths, you can loop those and updates the notes one by one.

That will probably be easier (and safer) than trying to write an update query.

Geert

[shimon]

Hi Geert,
I'm not looking to update via SQL. I'm just looking for a way to find all the notes that have such links.

I found it by searching for :
where t_object.notes like '%href%&#%\'.
It could probably be perfected, but this did the job for me.

Sincerely,
Shimon