excel - Getting "" in the file instead of " which is not expected -

-

there code in button click workbooks saved local text files.

workbook contains below info:

critical; insert ifparam values(3498,'tat_unalloctradesrec','string','if(string(c5)=string("tce - external hedge"),string("e"),if(string(c5)=string("tce - internal hedge"),string("i"),string(c5)))');

but output comes critical; 

insert ifparam values(3498,'tat_unalloctradesrec','string','if(string(c5)=string(""tce - external hedge""),string(""e""),if(string(c5)=string(""tce - internal hedge""),string(""i""),string(c5)))');

issue ever there " getting "" in output. can me in getting in workbook i.e; single double quote " instead of ""

please suggest if code change needed. code used :

private sub commandbutton1_click()     dim xlbook workbook, xlsheet worksheet     dim stroutputfilename string     dim n long, long, j long     dim mydata string, strdata() string, myarray() string     dim strpath string      strpath = activeworkbook.path '<~~ \\plyalnppd3sm\d$\temp\arun\tat\      thisworkbook.savecopyas strpath & "\temp.xls"      set xlbook = workbooks.open(strpath & "\temp.xls")      each xlsheet in xlbook.worksheets         if xlsheet.name <> "user_provided_data"             stroutputfilename = strpath & "\" & xlsheet.name & ".zup"             xlsheet.saveas filename:=stroutputfilename, fileformat:=xltextmsdos        n = n + 1              redim preserve myarray(n)             myarray(n) = stroutputfilename             debug.print stroutputfilename         end if     next      xlbook.close savechanges:=false      kill strpath & "\temp.xls"      = 1 ubound(myarray)         '~~> open files in 1 go , store them in array         open myarray(i) binary #1         mydata = space$(lof(1))         #1, , mydata         close #1         strdata() = split(mydata, vbcrlf)          '~~> write text file         open myarray(i) output #1          '~~> loop through array , check if start , end has "         '~~> , if ignore , write text file         j = lbound(strdata) ubound(strdata)             if left(strdata(j), 1) = """" , right(strdata(j), 1) = """"                 strdata(j) = mid(strdata(j), 2, len(strdata(j)) - 2)             end if             print #1, strdata(j)         next j         close #1     next end sub

easiest solution without looking @ code - add in line before outputting strdata(j) text file:

strdata(j) = replace(strdata(j), """""", """")

i'm sure there nicer ways, simple, quick , dirty fix!


Comments

Post a Comment

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

-
i have method method discussed , successful data entered 1 when more 1 can not database this programs my php form : <form class="form-horizontal" id="form-produk"> <div class="control-group" > <label class="control-label" for="kelas">kategori</label> <div class="controls"> <select class='form-control' name='id_kategori'> <?php $tampil=mysql_query("select * kategori order nama_kategori"); if ($id_kat==0){ echo "<option value=0 selected>- pilih kategori -</option>"; } while($w=mysql_fetch_array($tampil)){ if ($id_kat==$w[id_kategori]){ echo "<option value=$w[id_kategori] selected>$w[nama_kategori]</option>"; } else{ echo "<option value=$w[id_kategori]>$...
Read more

multithreading - Exception in Application constructor -

-
i wanna write snake game javafx , there exception don't know , want know how fix it. ( know it's not complete yet ) and want know , class extends application ( start override ) main in other programs? see , here not static void main bc didn't need, if want add main shoud do? it's exeption... exception in application constructor exception in thread "main" java.lang.nosuchmethodexception: main_snake.main([ljava.lang.string;) @ java.lang.class.getmethod(class.java:1819) @ com.intellij.rt.execution.application.appmain.main(appmain.java:125) and code : import javafx.animation.animationtimer; import javafx.application.application; import javafx.event.eventhandler; import javafx.scene.scene; import javafx.scene.canvas.canvas; import javafx.scene.canvas.graphicscontext; import javafx.scene.input.keyevent; import javafx.scene.layout.borderpane; import javafx.scene.paint.color; import javafx.stage.stage; import java.util.arraylist; /** * creat...
Read more

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -

-
i realize similar post others (e.g. this one ), there details missing posts might significant case. to start with, here's simplified program: #include "stdafx.h" #include <windows.h> #include <wincrypt.h> int _tmain(int argc, _tchar* argv[]) { // usage: certextract certpath char keyfile[] = "c:\\certificates\\public.crt"; byte lp[65536]; security_attributes sa; handle hkeyfile; dword bytes; pccert_context certcontext; sa.nlength = sizeof(sa); sa.lpsecuritydescriptor = null; sa.binherithandle = false; hkeyfile = createfile(keyfile, generic_read, file_share_read, &sa, open_existing, file_attribute_normal, null); if (hkeyfile) { if (readfile(hkeyfile, lp, getfilesize(hkeyfile, null), &bytes, null) && bytes > 0) { certcontext = certcreatecertificatecontext(x509_asn_encoding, lp, bytes); if (certcontext) { printf("yay...
Read more