Delete doble quotation characters in datatable variable

Help Studio
1

Hi all,

I have a datatable variable with info like this:

DELETE APP_ACCESS;
“INSERT into APP_ACCESS (‘$USER’,‘001’,‘ETI01’,‘####’,‘ETI_ESZ0’);”
“INSERT into APP_ACCESS (‘$USER’,‘001’,‘ETI01’,‘####’,‘ETI_0050’);”
“INSERT into APP_ACCESS (‘$USER’,‘001’,‘ETI01’,‘####’,‘ETI_0053’);”
“INSERT into APP_ACCESS (‘$USER’,‘001’,‘ETI01’,‘####’,‘ETI_0207’);”
“INSERT into APP_ACCESS (‘$USER’,‘001’,‘ETI01’,‘ETI_0067’,‘####’);”
“INSERT into APP_ACCESS (‘$USER’,‘001’,‘ETI01’,‘ETI_0021’,‘####’);”

It could be possible to delete the double cuotation of the beggining and the end and let like this:

DELETE APP_ACCESS;
INSERT into APP_ACCESS (‘$USER’,‘001’,‘ETI01’,‘####’,‘ETI_ESZ0’);
INSERT into APP_ACCESS (‘$USER’,‘001’,‘ETI01’,‘####’,‘ETI_0050’);
INSERT into APP_ACCESS (‘$USER’,‘001’,‘ETI01’,‘####’,‘ETI_0053’);
INSERT into APP_ACCESS (‘$USER’,‘001’,‘ETI01’,‘####’,‘ETI_0207’);
INSERT into APP_ACCESS (‘$USER’,‘001’,‘ETI01’,‘ETI_0067’,‘####’);
INSERT into APP_ACCESS (‘$USER’,‘001’,‘ETI01’,‘ETI_0021’,‘####’);

Thanks

2

Hi @christian.romero,

Since it is in datatable, you can use for each row and replace the “” by using expression as
row(“row_index”).tostring.replace(“”“”," ").

Hope this might solve your issue…

1 Like
3

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