Hi folks,
I'm working on a tool that queries a database based on user input, where this user input is a text parameter. The wildcard for the database is the percent (%) character. The user input, which is ultimately translated into the query, should be able to contain a % character. For example, one input field lets the user indicate which cancer cohort he or she is interested in, in a table of available cohorts, and the user should be able to give input like 'TCGA%" to indicate all TCGA cohorts.
The problem I'm having is that when % is given in the input field, it's translated (to X) by the time it reaches my tool's python script. I haven't been able to figure out the right way to escape the input so that % is not translated.
So, how do I escape this?
Thanks!
Melissa