How to delete string at 1st place in excel

Help Studio
21

Can you try this:
System.Text.RegularExpressions.Regex.Replace(row(“Address”).ToString.ToUpper,”[2]+“,”").ToString.Trim

  1. THOR ↩︎

  2. THOR ↩︎

1 Like
22

Thanks @Saranyajk for your efforts,
Input

Screenshot (706)
Screenshot (706)1920×1080 181 KB

Output I need :
Screenshot (710)
Screenshot (710)1800×678 54.4 KB

I want “THOR” and “thor” to be deleted only at the first place, But with your workflow “THOR” and “thor” are deleting everywhere

23

ok, you can split to string, check if first place is Thor, then delete

1 Like
24

what about at the end, you want thor or not?

1 Like
25

Yes I want it at the end or anywhere else , I want it to be deleted only if it is at starting

26

Thanks @suraj3501, I tried it…but not getting expected output

27

try this inside for each row

image
image620×647 13 KB

input is same as before
output image

1 Like
28

@Saranyajk Thanks for the work you have done for me…I tried your process…I am not getting the expected output

1 Like
29

can you show your work please

1 Like
30

Yeah, Once check this workflow
Process4.zip (2.3 KB)

1 Like
31

Main_Forum.xaml (99.4 KB)

32

IF condition is true, you have to use the replace activity, thats why

33

image
image1305×703 25.1 KB

1 Like
34

@Saranyajk Now I changed this as you said and I also saw your workflow,but still facing same problem.Once see this and tell me if any changes are there in this workflow
Process4.zip (2.4 KB)

1 Like
35

yes ofcourse, you need to write the new address in your datatable, and then write the datatable otherwise the values in datatable, dont change. for that assign row("address)=new_Address

36

@Saranyajk You mean I need to add New Address Column in the excel? or I need to add WriteLine activity and specify the new address datatable

1 Like
37

image

you need to add this assign, otherwise Datatable will not be updated

1 Like
38

first modify the database value and then write to EXCEL

1 Like
39

@Saranyajk Thank you…Now the first string got deleted everywhere but I kept “THOR” in middle…that one also got deleted
Input

Screenshot (721)
Screenshot (721)1837×632 56.6 KB

Output I got
Screenshot (722)
Screenshot (722)1920×655 54.2 KB

In 5th and 6th rows I kept “THOR” in middle of text…That one got deleted but as per the code that should not delete because we mentioned that only first place must delete if it contains “THOR”/“thor”

40

@Saranyajk Can you please check if anything is wrong
Process4.zip (2.5 KB)