syntax help when sending a string with quotes

[GJB56]

I am trying to send this string that contains ". I have tried multiple combinations using """ without luck.

sqlite3 /var/app/sql/abcd.db -header -column "select * from vol.hosts" | grep ’40:94’

The grep isn't necessary for most queries but it would be nice to know.

[GJB56]

I got it. just had to break it up. Here is an example:

crt.Screen.Send "sqlite3 /var/app/sql/ipho.db -header -column " & """select * from vol.hosts""" & " | grep '40:94'"

[bgagnon]

Hi GJB56,

Thanks for sharing your solution!