Good morning to all.
Here is an example of what I am trying to write into a text file: (This is not the whole query)
update ipsi.standard_scf
set key_eng = ‘2238724’
where key_eng = ‘102822’
and scf_type = ‘CUSTODIAN’
and i_std_stand_id in (select i_std_stand_id
In the Append Line Activities, I am doing something like this:
1st append:
"update ipsi.standard_scf
set key_eng = '"
2nd append statement:
rowNewBEMS(“New_BEMSid”).ToString
3rd append statement:
"’
where key_eng = '"
It’s a real pain that you can apparently only have two double quotes in each append line activity.
What I end up with in my Text file:
update ipsi.standard_scf
set key_eng = ’
2238724
’
where key_eng = ’
102822
’
and scf_type = ’
CUSTODIAN
’
and i_std_stand_id in (select i_std_stand_id
In Notepad++, there is a CR and an LN after each Append Line. How do you remove these in UiPath’s Append Line activity?