How to delete string at 1st place in excel

Help Studio
1

Process3.zip (2.2 KB)
Screenshot (702)
I deleted the string which is present in the first place i.e “THOR " in “Address” Column using Regular Expression and I got the Result like this :

Screenshot (704)
Screenshot (704)1920×638 56.2 KB

I used this expression in assign activity
System.Text.RegularExpressions.Regex.Replace(row(“Address”).ToString,”[1]+“,”").ToString.Trim
If I insert this “^” into the expression “THOR” is getting deleted, Its fine But I created another excel sheet…There I gave “thor” at start in some cells and “THOR” at start in some cells…I want a single statement to delete both “thor” and “THOR” at starting.I know that removing “^” will delete the lower case but I want to delete both lower and upper ones with single Statement…It will be really appreciable if anyone suggests me some idea.

  1. THOR ↩︎

2

hi,
can you try the below expression and check if it works.

Thanks…

  1. thor ↩︎

1 Like
3

@shaikmdrafi Thanks for the reply…I checked it.
I gave this one as input

Screenshot (708)
Screenshot (708)1901×629 54.8 KB

I got the Result like this
Screenshot (705)
Screenshot (705)1920×1080 180 KB

But I want Output in this manner
Screenshot (710)
Screenshot (710)1800×678 54.4 KB

I want “thor” and “THOR” to be deleted at beginning using the single statement…Can you please tell me any idea for that

4

Can anyone please suggest me some idea

5

read the excel and get it datatable
For each row in that datatable
get the row(“Address”) in a string ex Add_String
Assign Add_String=Add_String.replace(“Thor”,“”)
like this you can specify for THOR,thor etc.
Hope this solves your issue. Plaese try and let me know if it works.

1 Like
6

Hi @Saranyajk, Thanks for the reply, I want to delete both “thor” and “THOR” using one single statement in assign activity…How to do?

1 Like
7

image
image1096×370 13.1 KB

8

try this

9

Try this expression
@Kavyasri
System.Text.RegularExpressions.Regex.Replace(row(“Address”).ToString,”[1]+“,”").ToString.Trim

  1. thor|THOR ↩︎

3 Likes
10

Thanks for the help…I tried this but I am not getting the expected output

11

@hasib08 Thanks for the suggestion, I tried this expression now…I am not getting the expected output…I need “thor” and “THOR” to be deleted at the beginning but when I use this expression only “THOR” is getting deleted at the beginning…

12

Try this expression
@Kavyasri

13

image
image1037×639 21.9 KB

This perfectly works for me, if you still havent sorted, try this

1 Like
14

Thank you @hasib08 , I tried…still facing the same problem

15

image

my sample output

1 Like
16

Thank you @Saranyajk, can you please share me your input

17

image

1 Like
18

@Saranyajk,if you dont mind…can you please add “THOR” before agsahGSDH and try your workflow,and show me the Result you got.
Thanks &Regards

1 Like
19

Input image
Output Log image

1 Like
20

Please Mark it as solution, If it works for you, thanks, Happy Automation

1 Like