I was able to export a tab delimited text file and import it into an Access table, which gives me all of my old Rdio Shortcut names (articles and stories), and the URLs. If I wanted to do a batch search and replace of all the text in the MT database where the string “” (, in quotes) , and replace it with the info in , the field that holds the URL info, which has the whole Same text as the scName field

How might I do this? Is there anything that woudl help me do this? How would you do it? Do you know what I’m asking?

For example:

ID: 4
scName: 20 years
url: here is a whole url tag with ahref and the link….if I type it in here, it just shows the link and not what’s actually in the field…i forgot how to do the esc caharacters in MT

4 is the primary key
20 years is the Shortcut title (scname)
the a href string is the url field

I want to replace any occurrence of “20 years” in the MT database (anywhere that the exact string “20 years” (including the quotes) in the database, with the stuff from the corresponding url field, so that “20 years” is replaced with :
20 years

Possible?