Excel cell remove bracket word

Help Activities
, ,
1

IMG-20230816-WA0015
IMG-20230816-WA00151920×1080 253 KB

how to remove that barcket word??

2

Hey @bhavana_kolli ,

Excel Application Scope
Read Range (Output: inputDataTable)
For Each Row in inputDataTable
Assign
Left side: row(“Capital”)
Right side: System.Text.RegularExpressions.Regex.Replace(row(“Capital”).ToString, “[.*?]”, “”).Trim()
Excel Write Range (Input: inputDataTable)

Try this

I have used your input and below is the file as per your requirement
BlankProcess.zip (10.5 KB)

Below is the output Screenshot
image

Hope it helps you out

3

hai @bhavana_kolli

By using split Function we can remove…

inputstr.split(" "c)(0)
will get the 1st index value.

4

yourstring.split(" "c)(0).tostring

5

Hi @bhavana_kolli

Input1.Replace("[","").Replace("]","")

image
image818×403 14 KB

I hope it helps!!

6

it is throwing error like complete activity

7

@bhavana_kolli Can you please send us the screenshot of the error and also which activity is throwing the error

Have you tried the xaml file that i have attached with the above response , It worked fine in my environment

8

done in anaother way,tqs for your attention