Escape double quotes around a single character within a string

[anavagomez]

I am facing a problem that I hope I can get some help in this forum. I am retrieving values from a SQL Server data-table, loading them into an array to then use the array to add the items to a drop-down-list.


The problem that I have is that one of the values contains double quotes around one of the characters of the string.




This is the value: "A" Side Music, LLC


Because of the double quotes around the A, that value is not included in the drop-down-list, all other values are present.


The code that I have tried is this piece:

    For intRecord = 0 To UBound(arrRecords, 2)


        Name.AddItem (Chr(34) & arrRecords(0, intRecord) & Chr(34))


    Next intRecord

Is there any way someone could help me figure how to work around this problem?


Many thanks

[anavagomez]

I forgot to mention that I also tried to use only: Name.AddItem avarRecords(0, intRecord)

[CJ_London]

try replacing the double quotes with two double quotes

replace(arrRecords(0), Chr(34), Chr(34) & Chr(34))

[anavagomez]

did not work.

[anavagomez]

this worked:

Name.AddItem "'" & arrRecords(0, intRecord) & "'"

[anavagomez]

Thank you to Ajax for all his help to solve the issue I was having.