cancel
Showing results for 
Search instead for 
Did you mean: 

Expression Editor Escape Character for "

sastharpa
MVP
Any suggestion for the escape character for double quotes. I am trying to construct the below-mentioned line in the expression editor but not working.

"https://hostname:8443cription?wsdl,"user","pas",l7ac3a04,247276af252c,101,"5","25","1", manualtest, "0001","1","2","1.200", "2021-11-16""

Note" Entire line between ""

------------------------------
LAKSHMIGANESH Velayudham
------------------------------
VL Ganesh
Tech Arch RPA
7 REPLIES 7

john.hammond
Level 6
Hi there. To escape double quotes, append Chr(34). For example:  "This expression will contain the character " & Chr(34) & " here." will be displayed as below:

This expression will contain the character " here.

------------------------------
John Hammond
------------------------------

Hi @sastharpa

In order to escape double quotes you need use the double quotes symbol 4 times, hence your expression will become:

"https://hostname:8443cription?wsdl," & """" & "user" & """" & "," & """" & "pas" & """" & ",l7ac3a04,247276af252c,101," & """" & "5" & """" & "," & """" & "25" & """" & "," & """" & "1" & """" & ", manualtest, " & """" & "0001" & """" & "," & """" & "1" & """" & "," & "2" & """" & "," & """" & "1.200" & """" & "," & """" & "2021-11-16" & """"​


Try this out and let us know if it works!

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------


Hope it helps you out and if my solution resolves your query, then please mark it as the best answer

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Technical Business Analyst,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------

Hi @Devneet Mohanty,
 Thanks for your swift response. However, still it shows syntax error.
I also found another way using &[comma]& and it worked in my case.

Can you recommended some article to learn more about BluePrism Development techniques ?



------------------------------
LAKSHMIGANESH Velayudham
------------------------------
VL Ganesh
Tech Arch RPA

Hi L,

Nice that you found the solution to be a Data Item containing the character to be escaped and just concatenating it in a calculation stage. This works every time and leaves you with nice readable code.

On the learning BP, I can recommend the following:
  • BP University
  • Youtube: Dave the RPA guy (slightly more advanced features)
  • Youtube: Busy ping (for the more basic stuff)
  • Experience is built by rolling up your sleeves and get started. Work with BP, find a realistic project and go for it.


------------------------------
Happy coding!
---------------
Paul
Sweden
------------------------------
Happy coding!
Paul, Sweden
(By all means, do not mark this as the best answer!)

Thanks @Paul JHM van Doorn for your response and suggestions.​

------------------------------
LAKSHMIGANESH Velayudham
------------------------------
VL Ganesh
Tech Arch RPA

MichealCharron
Level 8
@sastharpa

To escape straight double quotes in a string literal, in the expression editor, you have to escape all the inside straight double quotes with another straight double quote. So your string would look like this:
"https://hostname:8443cription?wsdl,""user"",""pas"",l7ac3a04,247276af252c,101,""5"",""25"",""1"", manualtest, ""0001"",""1"",""2"",""1.200"", ""2021-11-16"""​

If it still has an error after that, copy the string and paste it into a text editor and look for curly double quotes. Sometimes curly double quotes can be copied over from another application and sometimes the BP Expression Editor gets stuck in a mode where every straight double quote typed in comes out as a curly double quote. Curly double quotes are just treated as a character within an expression.




------------------------------
Micheal Charron
Senior Manager
RBC
America/Toronto
------------------------------
Micheal Charron
RBC
Toronto, Ontario
Canada

Hi @sastharpa,

Glad to know that you found a resolution, but the syntax I gave is not incorrect as you can see from the below screenshot:

28468.png

Many times, I have seen that directly copy pasting expressions do cause some issues in some machines​ which I think text editor for the expression screen does not recognize properly. If you try to copy few sections at a time as well on each go, you should be able to get it work, I think. ​

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------


Hope it helps you out and if my solution resolves your query, then please mark it as the best answer

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Technical Business Analyst,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------