How can i use " quote without using it?

Help StudioX
,
1

Hi guys,

this is my first job,
please accet my apologies if this is wrong place.

my question is, in my SQL code i should use LEVEL word as a column name. As you know in oracle sql client you can not use it without double quote symbol. So, whenever i need to use my query, i write it down like “LEVEL” ,

the problem is starts here. as you all know i can not use double quote except beginning or ending in UiPath StudioX code editor. it gives me error.

any idea would help,

thanks.

2

@Krmi

To escape add an extra double quote like this ""

This should sort the issue

Cheers

3

inner doublequotes we escape with an aditional one

Hello "BOT", how are you? → "Hello ""BOT"", how are you?"

4

Or you could save all your queries in an excel file and read the values and use the same wherever required. Best option would be to save in a config file

To Start with - Do following actions

  1. Keep your queries in an excel file including the double quotes
  2. Read the excel sheet as a data table
  3. Loop and message box each row
  4. Double quotes would have been taken as expected

image
image886×667 30.7 KB

5

i face it when i use execute query action. i dont even except an output. it just cant read my code because of i need to use double quote in it. if i dont use it, code is not working because of column name.

6

@Krmi,

You can try putting it in like [LEVEL] in query
for example

Select [LEVEL] FROM XYZTable
7

Hello @Krmi

You could also use Chr(34) to create quotation marks.

Example:

Chr(34)+str_Text+Chr(34)

Regards
Soren

2 Likes
8

doesnt work :frowning: do you suggest any other option?

9

what was done in detail?

Just share with us the hardcoded statement (e.g. prototyed within a SQl client). Based on this we will assist in getting it dynamized / adapted

10

basically > i use oracle sql. and LEVEL word is an operator for it.
in my table, my column name has same word, LEVEL

In sql if i write this word in double quote then it works. > not LEVEL but “LEVEL”, it works.
the problem is > i can not do that in UiPath StudioX. because i cant use double quote in sql queries except beginning or ending.

i tried all of those options, none of them worked.