replacing a value in input tool using text box and action tool

Question

i am pulling data in input tool from SQL, given the SQL query is large in size, i am not able to replace a value in the query say date using simple text box and Action tool(replace value), can we use any formula in action tool to make that work?

danilang · Answer

Hi @jaisaman

It's only the display of the SQL that is truncated in the Action tool and not the actual string itself.  Just make sure this field is highlighted and enter the text that you want to replace in the Replace a specific string field

Dan

jaisaman · Answer

I tried that, but given that the SQL query is quite large, the action tool is not reading the entire query and just ending the query with ******

and hence the SQL query remains incomplete

OllieClarke · Answer

@jaisaman  If you are replacing a date which appears in your SQL query, and you want to replace all occurrences of it, then tick the 'Replace a specific string' and delete everything except the date in there