Replace dot with comma

Help Robot
, , , ,
1

Hello everybody,
I have a table, I need to replace the dot with a comma in column 2. please tell me how can this be done?

image
image312Ă—625 9.31 KB

2

@yulya

  1. Use Read Range activity to read the data from Excel file and it will give output as DataTable. Let’s say dtInput.

  2. And then use For Each Row activity to iterate one by one row.

      For Each row in dtInput
     row("Level") = row("Level").ToString.Replace(".",",")

  3. Finally use Write Range activity and pass above dtInput to write back to the Excel file.

4

Hi @yulya
FYI
another solution using LINQ
lets say u have read this in datatable

using linq try this expression
(From r In dtData.AsEnumerable
let ra = r.ItemArray.Select(Function (x) x.ToString.Trim.Replace(“.”,“,”)).toArray()
Select dtdataResult.Rows.Add(ra)).CopyToDataTable()

Use statement from above within an assign and assign it to an empty dataTable : dtdataResult

thanks

5

the expression row(“Level”) = row(“Level”).ToString.Replace(“.”,“,”) needs to be written to what activity?

6

@yulya You can use Assign Activity

8

you forgot “Level”

CurrentRow("Level").toString.Replace(".", ",")

9

I fixed it but the error didn’t go away.

image
image865Ă—536 16.7 KB

image
image794Ă—364 14.8 KB

10

left side should be CurrentRow("Level") not CurrentRow

1 Like
11

@yulya

Use Assign activity inside loop and pass left and right hand side values as below.

Left-side: currentRow(“Level”)
Right-side: CurrentRow(“Level”).toString.Replace(“.”, “,”)

12

it is works, thank you!

1 Like
13

image
when I used the replacement, some values were divided into digits incorrectly, for example, I had a value of 28.3352, but it became 283, 352

14

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