Share
Reportselect * from Table's
was we need to pass double quotes , i just want to replace in query itself
select * from Table''s
You’re offline. This is a read only version of the page.
160
select * from Table's
was we need to pass double quotes , i just want to replace in query itself
select * from Table''s
Could you please provide more details about your use case? Why do you need to replace double quotes with single ones? Even if you add them manually, wouldn't it work without any syntax issues? Could you elaborate on your use case so that we can assist you in a more appropriate manner?
Thanks,
Deenuji Loganathan 👩💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥
-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀
Hi @MitheshRpa ,
I don't think so we can do it. @Deenuji can you please confirm this.
(Note:- if you got your solution you can mark as solution and gives kudos)
Thanks & Regards
Vishnu Reddy
Without using replace text activity , can i replace direcly in query ?
Hi @MitheshRpa ,
Please find the attached solution.
Code:
All responses (
Answers (
Database.Connect ConnectionString: OLEDB_ConnectionString Connection=> SQLConnection
Text.Replace Text: $'''select * from [Sheet0$] WHERE [Type] <> \'e-Remito\';''' TextToFind: $'''\'''' IsRegEx: False IgnoreCase: False ReplaceWith: $'''\"''' ActivateEscapeSequences: False Result=> Replaced_Query
@@copilotGeneratedAction: 'False'
Database.ExecuteSqlStatement.Execute Connection: SQLConnection Statement: Replaced_Query Timeout: 30 Result=> QueryResult
Database.Close Connection: SQLConnection
(Note:- if you got your solution you can mark as solution and gives kudos)
Thanks & Regards
Vishnu Reddy
