How to remove "" from Write

[damzi]

Am unable to find a way to remove "" from my script below. The output file includes the "" and these need to be removed.

write #3,"okay"
write #3,"

http://<servername>/cognos/cgi-bin/ppdsisapi.dll?DC=Q&E=/CISC+Cubes/"

& Left$(sLoopFilename, Len(sLoopFilename) - 4) & "<CubeUrl>"
write #3,Format(Now, "dmmmyy h:mm:ss")

Any idea or help will be greatly appreciated.

Am also trying to add & "<CubeUrl>" to the url passed in the above script. But the output file does not pick up this portion of my script. Thank you !

 

[drlex]

damzi,
where does the "" occur?
If you add a couple of lines in place of the write #3, "http..etc
like

Dim strprompt as string

strprompt = "[URL unfurl="true"]http://<servername>/cognos/cgi-bin/ppdsisapi.dll?DC=Q&E=%2FCISC+Cubes%2F"[/URL] & Left$(sLoopFilename, Len(sLoopFilename) - 4) & "<CubeUrl>"
MsgBox strprompt
Write #3, strprompt

what gets shown on screen?

soi la, soi carre

 

[damzi]

Tried that solution - it still outputs the "" used in the script. Am trying to get rid of the inverted commas in my output.

 

[damzi]

using the above I get
"

http://<servername>/cognos/cgi-bin/ppdsisapi.dll?DC=Q&E=/CISC+Cubes/(cubename)<CubeUrl>"

Am trying to remove those inverted commas.

 

[CognosTechUser]

Use "Print" instead of "Write"