[image] I have scratched my head for too long but I couldn’t come with a feasible solution Can somebody help me with this ? There are 2 things which I need to perform in this Detect any number with double quotes and remove the comma inside of the number and then remove the double quotes De…

HI, Another approach: How about the following? [image] First convert input string to datatable because it seems csv data. Next, convert it to expected format using the following expression. dt = {dt.CLone.LoadDataRow(Enumerable.Range(0,dt.Columns.Count).Select(Function(i) if(Double.TryParse(d…

String Manipulation for apostrophes

Help Robot

Gokul001 (Gokul Balaji) December 22, 2022, 11:33am 2

Hi @Ishan_Shelke

You can try with Regex expression

System.Text.RegularExpressions.Regex.Replace(YourString,""|.00","").Tostring

Regards
Gokul

Topic		Replies	Views
Identifying digits inside apostrope Robot robot , question	8	607	January 6, 2023
Remove apostrophe from a column Help	7	1821	June 14, 2023
Removing comma Learning Hub activities , question , system	17	5202	July 4, 2020
Can anyone help me make regular expression to solve this issue Help	8	2527	September 12, 2019
Regex.Replace string with quotation marks Help studio	8	4113	July 2, 2020

String Manipulation for apostrophes

Related topics