Insert double quotes text and save it as a text file

[sbumeshqlik]

Hi,

I am having problem  inserting " and storing it as text file. in text file  it inserts 2 double quotes ""  instead of  ".

TextFile:

            Load * Inline [

                TEXT

                cd "C:\Program Files (x86)\WinSCP"

];

store TextFile into c:\text\mytext.txt   (txt);

output text file  is shown below.

What I Would like to see is                         cd "C:\Program Files (x86)\WinSCP"  

Thanks

[anbu1984]

When you view the file using Excel, you won't see the extra quotes and also if you read this file in Qlikview, you don't get extra quotes

[sbumeshqlik]

Anbu,

problem is, I need to run this as  a batch file. 

[Anonymous]

TextFile:

load

'cd ' & chr(34) & 'C:\Program Files (x86)\WinSCP' & chr(34) as TEXT

autogenerate 1

;

[Anonymous]

Actually probably better to use the 8.3 format of C:\Program Files (x86)\WinSCP which is c:\progra~1\WinSCP so you don't need the quotes at dos level.

And set the field name to rem that dos will ignore.

Echo :

load

'cd c:\progra~1\WinSCP' as rem

autogenerate 1

;

store Echo into c:\text\mytext.txt   (txt )

[sbumeshqlik]

       bill.markham

Thanks for your reply,  but  I am getting wrong output.  instead of   cd  "C:\Program Files (x86)\WinSCP"

TEXT

"cd ""C:\Program Files (x86)\WinSCP"""

[Anonymous]

Are you using the 8.3 format of C:\Program Files (x86)\WinSCP which is c:\progra~1\WinSCP

Echo :

load

'cd c:\progra~1\WinSCP' as rem

autogenerate 1

;

store Echo into c:\text\mytext.txt   (txt )

[sbumeshqlik]

Hi Bill,

I agree with you that we can generate using the 8.3 format

Next I   need to generate this  in a text file.

"C:\Program Files (x86)\WinSCP\WinSCP.com"  /command "option batch abort"  "option confirm off"         "bin"  "exit"