Replace single quote with double single quotes

[karthik_kulkarni1 (karthik kulkarni)]

Hi,

I want to replace single quotes with double single quotes
ex: PSY’D with PSY’'D

This should replace from entire data table not on a particular column using UiPath.

[mkankatala (Mahesh Kankatala)]

HI @karthik_kulkarni1

- Assign -> Input = "PSY'D"
- Assign -> Output = Input.Replace("'","''")

Check the below image for better understanding.

To change the single quote with double single quotes for a column in a datatable.
Take a for each row in datatable activity inside of this insert the assign activity.

- Assign -> Currentrow("Column name") = Currentrow("Column name").Replace("'","''")

Hope it helps!!

[pravallikapaluri]

Hi @karthik_kulkarni1

For Each row In dataTable.Rows
    For Each col In dataTable.Columns
        row(col) = row(col).ToString.Replace("'", "''")
    Next
Next

[ppr (Peter Preuss)]

@karthik_kulkarni1

PSY’D

A LINQ Approach

LINQ query to update(replace)datatable in uipath

@Rachel7 this is maybe a too quick shot as it replace any space in any column to NA and returns a datatable. But you can give a try (From r In dtData.AsEnumerable Select ia = r.ItemArray.toList Select ic = ia.ConvertAll(Function (e) e.ToString.Trim.Replace(" ","NA")).toArray() Select dtCorrected.Rows.Add(ic)).CopyToDataTable() NEW VERSION, simplified: (From r In dtData.AsEnumerable let ra = r.ItemArray.Select(Function (x) x.ToString.Trim.Replace(" ","NA")).toArray() Select dtCorrected.Rows.…

From r In dtData.AsEnumerable
let ra = r.ItemArray.Select(Function (x) x.ToString.Trim.Replace("'","''")).toArray()
Select dtCorrected.Rows.Add(ra)).CopyToDataTable()

[vrdabberu (Varunraj Dabberu)]

HI @karthik_kulkarni1

Please check the below xaml

ReplaceSingleQuotesWithDoubleQuotes.txt (345 Bytes)
Main.xaml (18.5 KB)

Input:

output:

Regards

[karthik_kulkarni1 (karthik kulkarni)]

This is working but the issue is when I am trying to push same in to database I am getting error , as it is not accepting single quotes.