Get text from a string sentence

[vikrantyadav]

Hi Guys,

I have a sentence " Welcome to the application JIRA, please contact us for setup".

I want to extract the JIRA from the sentence and assign it to variable “application_name”. Please suggest.

thanks

[MichaelL]

@vikrantyadav
You can use the Substring Method or Regular Expression. It really depends on how dynamic is this sentence.

[vikrantyadav]

Hi Michael,
thanks for the suggestion.
But i need a word written after application and before " , "

thanks

[MichaelL]

Use Regular Expression either using the Assign activity or Matches activity.
Expression is “(?<=application.)(.*)(?=,)”

[Srini84 (Srinivas Kadamati)]

@MichaelL

(?<=application.)(.*)(?=,)

@vikrantyadav

Check as below

Hope this helps you

Follow Link

Thanks

[vikrantyadav]

Regex is not giving the correct output. it’s showing this is output not an application name.
System.Linq.Enumerable+d__97`1[System.Text.RegularExpressions.Match]

[Srini84 (Srinivas Kadamati)]

@vikrantyadav

The output of the Regex Matches is a Collection

So if you want to get the result then use Variable(0).ToString to access the first value

Hope this helps you

Thanks

[vikrantyadav]

It’s giving output this :- JIRA, please contact us for setup.
not only JIRA.

[Srini84 (Srinivas Kadamati)]

@vikrantyadav

Welcome to the application JIRA, please contact us for setup

@vikrantyadav

Check as below

Hope this helps you

Follow Link

Thanks

[vikrantyadav]

It’s fixed now. Thanks Mate.

[vikrantyadav]

If we have . instead of ,
in this case do i need to use this code :- “(?<=application.)(.*)(?=.)” ?

[MichaelL]

That’s right! You can test your regular expression code script in here.