Replace comma with dot

[Kuldeep_Pandey]

Hey guys I have one column with data in (,) I want to replace , with (.) Please help

[Steven_McKeering]

Hey @Kuldeep_Pandey

See the post:

Rename column in datatable

HI @Naga_Abhishek_Reddy_Chepp Check out the Video link [How to Rename Columns in DataTable in UiPath?] Can you share the sample input and expected output?

Cheers

Steve

[Kuldeep_Pandey]

Sorry I think some misunderstanding
I want to remove one column data which have (,) with (.)
Column have many data like
4,2
5555,2
2728282,5
all i want in(.)

[Nitya1 (Nitya Tomar)]

Hi @Kuldeep_Pandey

Use the “Invoke Method” activity to call the “Replace” method on the column you want to modify.
Configure the parameters: In the “Parameters” field, enter the following values:
a. “oldValue” = “,”
b. “newValue” = “.”
Save the data: Use the “Write Range” activity to write the modified data back to the source file.

Thanks!!

[fernando_zuluaga]

HI

Already solved here

REplacing Values in a column of datatable

e.g. invoke code and: yourDataTable.AsEnumerable.ToList.ForEach(Sub(row) row(“ColNameOrIndex”)= row(“ColNameOrIndex”).ToString.Replace(“your old value”,” your new value”))

Regards!

[vishal.kp (vishal)]

Hi @Kuldeep_Pandey ,

Use the following expression in invoke code by passing your data table as in/out argument:

dt.AsEnumerable.ToList.ForEach(Sub(row) row("ColumnName") = row.Field(Of String)("ColumnName").Replace(".", ","))

Regards,

[Kuldeep_Pandey]

Error Coming

[varunk (Varun Kumar)]

@Kuldeep_Pandey

Please find the below syntax to replace with “.”

Input =Text,S

Ex : Input.ToString.replace(“,”,“.”)

Output : text.S

Thanks & regards
Varun