How to Remove or replace the Comma in between name in excel

Help Studio
, ,
1

Hi All

How can I remove the Comma in middle name from excel

image

1 Like
2

Do you mean to replace all the commas in the line description column ?

3

Hi @Sam_H,

try with Update Row Item Activity

image
image617×604 16.3 KB

Thanks,
Rajkumar

4

HI @Sam_H

Try with this expression

(From d In DtBuild.AsEnumerable()
Let ra = d.ItemArray.Select(Function (x) x.toString.Replace(",","")).toArray
Select rc = DtOut.Rows.Add(ra)).CopyToDataTable

Regards
Gokul

5

Another Method @Sam_H

You can also try with Find/Replace Value activity

Check out this XAML file

Find And Replace.xaml (11.1 KB)

6

Yes i have to remove or replace it commas

7

input
image

Output
image

Sequence.xaml (9.3 KB)

Thanks,
Rajkumar

8

@Sam_H ,
Try this

In for each row datatable loop

Currentrow("Invoice/CM #")=Currentrow("Invoice/CM #").ToString.Replace(",","").Trim
or
Currentrow(2)=Currentrow(2).ToString.Replace(",","").Trim
9

Hi @Sam_H

Use for each row datatable activity

Currentrow(“ColumnName”)=Currentrow(“ColumnName”).ToString.Replace(“,”,“”)

Replace “ColumnName” with the column where you want to replace comma.

10

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