How do I replace "," with ";"?

[uio (uipath test)]

Hey All,

I have an Excel column named “Email” containing Email IDs in it. When there are multiple values in a cell, a comma is used to separate two IDs.

The field where I enter the Email IDs doesn’t allow to enter commas. But accepts semicolons.

How do I replace a comma with semicolon ?

Thank You.

[pravallikapaluri]

Hi @uio

Excel Application Scope
  - Read Range (output: DataTable)

For Each Row in DataTable
  - Assign
    - To: row("Email")
    - Value: row("Email").ToString().Replace(",", ";")

Write Range (input: DataTable)

Hope it helps!!

[uio (uipath test)]

Thank you, it works perfectly.