Welcome, Guest. Please Login.
IRobotSoft Robot
08/07/20 at 17:57:13
News: IRobotSoft is the enssential tool for Internet marketing and SEO work!
Home Help Search Login
Google
 


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




Posts: 22
Gender: male
How to include double quote in the string
06/18/16 at 15:56:43
 
Hi,
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
'=hyperlink(""'+url+'"",""'+urldata+'"")'
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
'=hyperlink("httpurl","Data")'
 
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
 
regards
Babu
Back to top
 
 

regards
SB
  IP Logged
IRobotSoft Administrator
IRobotSoft Administrator
*****


IRobotSoft, the Best
Internet Robot
System

Posts: 1608
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