Welcome, Guest. Please Login.
IRobotSoft Robot
01/22/21 at 18:16:08
News: Welcome to the IRoboSoft Visual Web Scraping and Web Automation forum.
Home Help Search Login

Pages: 1
Send Topic Print
How to include double quote in the string (Read 1489 times)
Junior Member

Posts: 22
Gender: male
How to include double quote in the string
06/18/16 at 15:56:43
while trying to create csv file which can be opened in excel I am using the following in save variable section as expression for the one of the output column
note: url and urldata are variables
excel looks for double quotes only and does not accept single quote around string constant
for example final value in the excel cell needs to be as follows
tried single double quote as well and that also did not work
tried using latest irobot version (2.8.2-2016-01-17) as well but did not help
please let me know how to achieve this
thanks for your help
Back to top

  IP Logged
IRobotSoft Administrator
IRobotSoft Administrator

IRobotSoft, the Best
Internet Robot

Posts: 1609
Gender: male
Re: How to include double quote in the string
Reply #1 - 06/19/16 at 12:07:36
It looks like you are not able to put double quots when using Save Variables.  
You can compose the lines you need directly instead, and use AppendFile function to write to files, such as:  
AppendFile('testcsv.csv', '"=hyperlink(""'+url+'"",""'+urldata+'"")"\r\n')
Back to top

The Administrator.
WWW   IP Logged
Pages: 1
Send Topic Print