Write text with double quotes to datatable fails

Help Studio
,
1

Hi
i need to write text with double quotes in it to a datatable. For example: (this is a “test”)

First it is assigned to a variable: myVar = “(this is a” + “”“test”“” + “)”.

When I write myVar with a log message to the output, it is ok: (this is a “test”)
When I write myVar to a datatable, there are too many double quotes: (this is a ““test””)

image

I tried several ways to avoid this by manipulating the text: try with different number of quotes, with chr-codes etc

Is this a bug or is there a solution for this?

KR
Johan

3

@TALLIEU_Johan

Can you please show the assign of myvar…

Ideaaly this should work

"(this is a ""test"")"

Cheers

4

Result in datatable: (this is a ““test””), so still too many quotes

5

@TALLIEU_Johan

Please check by writing to immediate panel or a file you would see only one

Immediate:
image

Locals
image

in local panel it is showing with escape character

cheers

6

image

7

@TALLIEU_Johan

in Immediate if you check whole datatable it will show with double quotes

check with the value in row like mydt.Rows(0)(0)

cheers

8

image

9

I need to write the data table to an excel file, and it copies the backslashes also

10

@TALLIEU_Johan

Those are just escape characters…if you write the dataTable and check you would see that it would not write any thing extra

image

cheers

12

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