DequotedString(QuotedText: String[,Character:String]): String
Returns dequoted string version of the given QuotedText.
DequotedString function has these named arguments:
Parameter |
Description |
QuotedText |
Required. Text string to be dequoted. |
Character |
Quoting character, default value " |
Sample code:
S = "8" & """" & " pipe"
Quoted = QuotedString(S)
Dequoted = DequotedString(Quoted)
Print "S: " & S
Print "Quoted: " & Quoted
Print "Dequoted: " & Dequoted
Returns:
S: 8" pipeQuoted: "8"" pipe"Dequoted: 8" pipe
Sample code using character:
S = "8" & "'" & " pipe"
Quoted = QuotedString(S,"'")
Dequoted = DequotedString(Quoted,"'")
Print "S: " & S
Print "Quoted: " & Quoted
Print "Dequoted: " & Dequoted
Returns:
S: 8' pipe
Quoted: '8'' pipe'
Dequoted: 8' pipe