bchumney/gist:7d5f9fd90b18e998591fa31a4c100277

Created March 31, 2023 17:47

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/bchumney/7d5f9fd90b18e998591fa31a4c100277.js"></script>
Save bchumney/7d5f9fd90b18e998591fa31a4c100277 to your computer and use it in GitHub Desktop.

Download ZIP

Excel function to update sourced url entry

Raw

gistfile1.txt

=CONCATENATE("UPDATE edf_url_sourcing SET url = replace(url, '", A2, "', '", B2, "'),  resource = replace(resource, '", A2, "', '", B2, "') where id = ", C2, ";")

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment