Double Quote Issue

4 posts / 0 new
Last post
leylalkan
Offline
Joined: 11/27/2019 - 03:43
Double Quote Issue

Hi,
I want to let users type 20181231, so I want to get the following via letting a variable be equal to that date users type.
task.AddExtraction dbName, "", acilirListeVerisi1  & ">" & " ""20181231""  " 
That is if I let var=dlg.txt1, then how should I modify (task.AddExtraction dbName, "", acilirListeVerisi1  & ">" & " ""20181231""  ") so that I can still get the desired code when a user type 20181231 manually?
I tried this (task.AddExtraction dbName, "", acilirListeVerisi1  & "> "" " & var & " "" " ), but it didn't work. Any help would be appreciated. 
 
 

leylalkan
Offline
Joined: 11/27/2019 - 03:43

I tried this one: acilirListeVerisi1  & ">" & """" & var & """"
Luckily it worked!
 

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

You could have also done 

acilirListeVerisi1  & ">" & chr(34) & var & chr(34)

The chr(34) is the ASCII number for the double quotes, what you did is correct but sometime it is easier to write it this way.

leylalkan
Offline
Joined: 11/27/2019 - 03:43

Wow, yes this is way easier. Thanks