StephenRM Member Jun 24, 2021 #1 Can someone help me to remove the double quote and single quote from the text/ string..
MarcoRome Expert Licensed User Longtime User Jun 24, 2021 #2 B4X: Dim test As String = $"Remove 'quote' and "double quote""$ test = test.Replace($"'"$,"").Replace($"""$,"") Log(test) Upvote 0
B4X: Dim test As String = $"Remove 'quote' and "double quote""$ test = test.Replace($"'"$,"").Replace($"""$,"") Log(test)
StephenRM Member Jun 24, 2021 #3 MarcoRome said: B4X: [CODE=b4x]Dim test As String = $"Remove 'quote' and "double quote""$ test = test.Replace($"'"$,"").Replace($"""$,"") Log(test)[/CODE] Click to expand... Thanks so much the above works for : B4X: Dim test As String = $"Remove 'quote' and "double quote""$ But in my case, the text feed is from Database, so when ever the double quote or single quote appear, I want to Trim. I tried the method that Klaus mentioned about QUOTE, I tried Chr(34) and Chr(39), no result. Upvote 0
MarcoRome said: B4X: [CODE=b4x]Dim test As String = $"Remove 'quote' and "double quote""$ test = test.Replace($"'"$,"").Replace($"""$,"") Log(test)[/CODE] Click to expand... Thanks so much the above works for : B4X: Dim test As String = $"Remove 'quote' and "double quote""$ But in my case, the text feed is from Database, so when ever the double quote or single quote appear, I want to Trim. I tried the method that Klaus mentioned about QUOTE, I tried Chr(34) and Chr(39), no result.