How to remove [ ] from column in excel

Help Forum
, , ,
1

Hi all,
How to remove the from column city in excel file. Please check the below file.
test.xlsx (11.1 KB)
Please guide me on this.

2

@lakshmi.mp,

Do you need to remove it after reading the file as datatable or in the file itself you need to remove it.

3

Hi @lakshmi.mp

Try this in Invoke Code

dt.AsEnumerable().ToList().ForEach(Sub(r)
            r("Column") = r("Column").ToString().Replace("[","").Replace("]","")
End Sub)

Regards,

1 Like
4

@lakshmi.mp

image
image828×580 31.5 KB

image
image887×265 10.7 KB

Output:

image
image432×687 8.93 KB

Regards,

2 Likes
Forum Engagement Daily Reports
5

Hi @lakshmi.mp

Use For Each row in datatable
assign: row("City") = System.Text.RegularExpressions.Regex.Replace(row("City").ToString(), "\[|\]", "").Trim()

6

Hi @lakshmi.mp

You can use a simple
Read Range Workbook: read the sheet.
Use a loop For each ROw in datatable
use an assign activity:

CurrentRow("City")=CurrentRow("City").toString.Trim("[]".ToCharArray)

Write Range in same sheet or other one.
Here’s a sample xaml.
test.xlsx (10.2 KB)
Test.xaml (8.4 KB)

Happy Automation! :smiley:

7

Hi @lakshmi.mp

CurrentRow("City")=CurrentRow("City").ToString().Replace("[", "").Replace("]", "")

image
image676×693 31.3 KB

8

Hi @lakshmi.mp

Try below steps

  1. Use Read Range Activity
  2. Use For Each Row in Data Table Activity
  • Take Assign Activity

CurrentRow("City") = CurrentRow("City").ToString.Trim("[]".ToCharArray)

Hope it’ll helps you :slight_smile:
Cheers!!

9

@Sai_chnadrika_Kopparapu , thanks a lot for helping. It’s working fine

1 Like
10

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