Add double quatos to variable in add data row activity

Help Studio
, , ,
1

Hi,

I wanna add " to my strings in add data row activity and i am doing it with using Chr(34) like this:

{Chr(34) + in_TransactionItem.SpecificContent(“Kaynak para birimi”).ToString + Chr(34), Chr(34) + in_TransactionItem.SpecificContent(“Kaynak para birimi”).ToString + “:” + in_TransactionItem.SpecificContent(“Hedef para birimi”).ToString + Chr(34), Chr(34) + in_TransactionItem.SpecificContent(“Hedef para birimi”).ToString + Chr(34) , Chr(34) + in_TransactionItem.SpecificContent(“Kur”).ToString + Chr(34) , Chr(34) + in_tarih + Chr(34)}

but my solution is this:

“”“EUR”“”,“”“EUR:TRY”“”,“”“TRY”“”,“”“29.98"”“,”““Fri Jul 28 08:10:13 EET 2023"””

UiPath adds extra double quatos while using Chr(34) i dont know why?

3

Hi @erimbetul

Instead of using Chr(34) to add double quotes, you can use a custom format that doesn’t include the extra quotes

{“”" + in_TransactionItem.SpecificContent(“Kaynak para birimi”).ToString + “”“”,
“”" + in_TransactionItem.SpecificContent(“Kaynak para birimi”).ToString + “:” + in_TransactionItem.SpecificContent(“Hedef para birimi”).ToString + “”“”,
“”" + in_TransactionItem.SpecificContent(“Hedef para birimi”).ToString + “”“”,
“”" + in_TransactionItem.SpecificContent(“Kur”).ToString + “”“”,
“”" + in_tarih + “”"}

Hope it helps!!

4

Hi @erimbetul

Try this:

{"""" + in_TransactionItem.SpecificContent("Kaynak para birimi").ToString + """",
 """" + in_TransactionItem.SpecificContent("Kaynak para birimi").ToString + ":" + in_TransactionItem.SpecificContent("Hedef para birimi").ToString + """",
 """" + in_TransactionItem.SpecificContent("Hedef para birimi").ToString + """",
 """" + in_TransactionItem.SpecificContent("Kur").ToString + """",
 """" + in_tarih + """ "}
5

Hi @erimbetul - Please check the below thread

6

i get exactly the same result before, i dont know why :frowning:

7

i get the same result :frowning: UiPath always adds extra " in add data row activity…

8

@erimbetul

try this:

{"""" + in_TransactionItem.SpecificContent("Kaynak para birimi").ToString.Replace("""", "") + """",
 """" + in_TransactionItem.SpecificContent("Kaynak para birimi").ToString.Replace("""", "") + ":" + in_TransactionItem.SpecificContent("Hedef para birimi").ToString.Replace("""", "") + """",
 """" + in_TransactionItem.SpecificContent("Hedef para birimi").ToString.Replace("""", "") + """",
 """" + in_TransactionItem.SpecificContent("Kur").ToString.Replace("""", "") + """",
 """" + in_tarih.Replace("""", "") + """ "}
9

you saved my life thannkkkk you :slight_smile:

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.