How to extract a string from start till specific character

[Karan28 (Karan Arora)]

Hi , I have a string

string:- schedule!E26

I need to have a string from start till ! which means - schedule

[TimK (Tim Kok)]

You can use something called substring along with getting the index of !

I have given 2 options below:

StringVar.Substring(StringVar.IndexOf("!")).ToString =!E26

StringVar.Substring(StringVar.IndexOf("!")+1).ToString = E26

[Yoichi]

Hi,

Hope the following helps you.

text.Split({"!"c})(0)

OR

System.Text.RegularExpressions.Regex.Match(text,"^.*?(?=!)").Value

Regards,

[Pratik_Wavhal]

Hi @Karan28

Can be also done by following way :-

Mark as solution and like it

Happy Automation

Best Regards
Er Pratik Wavhal

[Karan28 (Karan Arora)]

Thankyou so much everyone for the solution. I dont know whom solution to mark as solution

[iVishalNayak]

@Karan28

schedule!E26

use regex pattern .*(?=!)

[Pratik_Wavhal]

Hi @Karan28

Heh heh heh

The one you feel more efficient n suitable for your query mark it as a solution.

As marking as a solution helps other candidate while searching.
If some is facing same issue and want the solution so that person will directly gets directed to the exact solution that helps you to solve the same query.

So for that mark as a solution the one you feel that it as more efficient.

Happy Automation

Best Regards
Er Pratik Wavhal