I'm developing a web page using VB.NET that will write a string to a file (txt) based on user input, using the FileOpen/FileClose functions which works fine. User entry type (either textbox or ddl) has not been determined yet, so in the meantime, I've hard coded my strings:
      Dim strFY = "salehistp:fyear"
      Dim strPrd = "salehistp:period"
      Dim strconc As String = strFY + " " + strPrd

The problem I have is that the text file that I write to using the FileOpen/FileClose functions contains the string with double quotation marks which I can't use in my text file:
      "salehistp:fyear salehitsp:period"

I've tried the replace:
      strconc.Replace("""", "")

Also the CleanInput function below passing strconc (CleanInput(strconc)):
     Function CleanInput(ByVal strIn As String) As String
       ' Replace invalid characters with empty strings.
         Return Regex.Replace(strIn, "[^\w\.@-]", "")
     End Function

And I've tried using the following function passing strconc in the same manner:
    Function CheckSQ(ByVal lsInput)
      Dim llPos
      Dim lsOutput

      lsOutput = lsInput

      llPos = 1
      Do While llPos <> 0
         llPos = InStr(llPos, lsOutput, "'", vbTextCompare)

         If llPos <> 0 Then
            lsOutput = Left(lsOutput, llPos - 1) & "`" & Right (lsOutput, Len(lsOutput) - llPos)
         End If
      Loop

      llPos = 1
      Do While llPos <> 0
         llPos = InStr(llPos, lsOutput, """", vbTextCompare)

         If llPos <> 0 Then
            lsOutput = Left(lsOutput, llPos - 1) & "`" & Right(lsOutput, Len(lsOutput) - llPos)
         End If
      Loop

      CheckSQ = lsOutput
   End Function

None of these options have worked for me. My text file still contains data I wrote to it with double quotes. Any ideas on what I'm doing wrong or what can be done differently to remove the double quotation marks?

Your time is greatly appreciated.

hi there.. you are adding the double quotations in other part of your code, since        will produce the string you need...
how are you storing it into the text file?? maybe there is the problem...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

I'm trying to strip the string of it's double quotes before i write it to the text file. I assign a label (lblFYPrd) on my page the contents of the string (after trying to strip the quotes) and then us the value of the label to write to the text file. I'm using the following code to write my string to the text file.
  FileOpen(1, "c:\somepath\TESTFILE.txt", OpenMode.Output,
    OpenAccess.Write, OpenShare.Shared)
      Write(1, lblFYPrd.Text)
  FileClose(1)

does this answer your question? Thanks

Based on the code I've seen so far, your string should not contain any quotes. How are you assigning the value to the label? Can we see that code?

-Peter

found it..

the write function add double quotes around the strings. Read this to have a better understand:
http://msdn2.microsoft.com/en-us/lib...tem.write.aspx

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

lblFYPrd.Text = strconc.Replace("""", "")

The code from start to finish:
     Dim strFY = "salehistp:fyear"
      Dim strPrd = "salehistp:period"
      Dim strconc As String = strFY + " " + strPrd
      CleanInput(strconc)
      CheckSQ(strconc)

      lblFYPrd.Text = strconc.Replace("""", "")

     FileOpen(1, "c:\somepath\TESTFILE.txt", OpenMode.Output, OpenAccess.Write, OpenShare.Shared)
      Write(1, lblFYPrd.Text)
      FileClose(1)

Hope this helps. Thanks

excellent read. Thank You. I used the Print instead of the Write and now my string has no double quotes or a comma at the end.

There is still one thing I don't understand. When I debug this page and check the contents of the string after passing it through each function and using the replace, it appears that the quotes are still a part of the string. Are the functions working or it it the print that removes my quotes.

Thanks

where are you checking your string?? maybe is the same problem.. you are seeing quotes b/c you are looking at a string..

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

I'm checking the contents of the string via the WATCH when debugging and hovering over the variable (lblFYPrd.Text) with the mouse.

As long as the quotes are removed in the text file :).

Thanks

I think what Gonzalo is saying is that when you look at a string value in the debugger the debugger shows the string inside of quotes simply because it is a string (versus an integer or other non-string type). The quotes are not actually characters within the string itself.



-Peter