How to add or concatenate double quotes with String Variables?

Help Studio
,
1

I have a Row(“ColumnName1”), Row(“ColumnName2”) and Row(“ColumnName3”)as variables and I want to enclose them with double quotes. How do I do this?

2

Hi @wdescalsota

Row(“ColumnName1”) = “First”
Row(“ColumnName2”) = “Second”
Row(“ColumnName3”) = “Third”

Each variable with double quotes or as a whole string with double quotes

Like this “First”,“Second”,“Third”

or

Like this “First,Second,Third”

3

Replace
strText with Row(“ColumnName1”)
strText2 with Row(“ColumnName2”)
strText3 with Row(“ColumnName3”)

This syntax “”“” + strText + “,” + strText2 + “,” + strText3 + “”“” will return

image

This syntax “”“” + strText + “”“,” + strText2 + “”“,” + strText3 + “”“” will return

image

1 Like
4

I’m trying to generate an insert query using the Row(ColumnName) as data for the insert query

eg. Insert Into SAMPLETABLE (ColumnName1, ColumnName2, ColumnName3)
Values (Row(“ColumnName1”), Row(“ColumnName2”), Row(“ColumnName3”))

5

I’m getting slashes image when I try using image

6

the TestVar is = “123”

7

Like this “First”,“Second”,“Third”

8

You can replace the strtext with your variable as I said earlier… thanks

9

I’m getting slash when I tried the solution. image My assign is image and the default value is

image
image723×54 3.56 KB

10

Try using message box or log message because in local panel slash will come.

11

I tried them in write line activity and it seems to work fine, will this be applicable when I use it as sql query?

12

yes it will be work fine

but for sql query we have pass value into the single quotes right?

13

like some sort of conversion after the double quotes?

14

Could you explain in detail I couldn’t understand the context correctly…

15

like, there will be some replacement of double quotes into single quotes? was referring to your last message regarding the pass value into single quotes.
You may expound it better so I may understand better

16

what my workflow would be is that after extracting data from the excel file, I’ll make an insert query and using the gathered data, those will be set as the values that will be enclosed in double quotes. and after applying the double quotes. will use the created string to an execute query activity

17

Hi,
if number of variables are the same, you can try:

output = String.Format("""{0}"",""{1}"",""{2}""", var1, var2, var3)

image
image914×131 7.4 KB

Output:
image

1 Like
18

will this be safe to use in an execute query activity?

19

strVar1=row(“columnName1”).Tostring
strVar2=row(“columnName2”).Tostring
strVar3=row(“columnName3”).Tostring

Assign Activity
strVar=strVar1+strVar2+strVar3
message box
“”" +strVar+“”"

20

I am using String.Format () in SQL and REST API queries. Everything is OK.