How to Add single quotes to string

Help Studio
1

Hi All,

I want to pass database output with single quotes to query how to do that.
I am converting database out to list and writing in text file with comma separated i want to add single quotes as well.Below is my output
182390141,182390138,182390150,182390554,182390552,182389990
Expecting as ‘182390141’,‘182390138’,‘182390150’,‘182390554’,‘182390552’,‘182389990’

Can some one help me on this

2

ExecuteQueryCod_Dn_table.xaml (7.1 KB)

3

Hi,

Can you try the following expression?

out_FiterString = System.Text.RegularExpressions.Regex.Replace(out_FiterString,"\d+",function(m) "'"+m.Value+"'")

Regards,

4

@thima

I am unable to open your xaml file, you can add project.json file too

That will easy for others to open your project file

Check below as you need like below

image
image747×422 17 KB

Hope this helps you

Thanks

2 Likes
5

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