String manuplation

[RACHEL_PAUL]

Hi,

In a for each loop i use a get text activity. The data from get text goes through several if statements. In my workflow i look for the words
“Mobilisation: No” . Sometimes there is space between the colon and sometimes there is no space eg- “Mobilisation:No”.

I currently write the if statement this way

GetTxtVar.ToUpper.Contains(“MOBILISATION: N0”)

Q. How to i wtite my if statement which satisfies both the conditions ?

[Anil_G (Anil Gorthi)]

@RACHEL_PAUL

You can use regex match

System.Text.RegularExpressions.Regex.Match(str,"MOBILISATION:\s+NO",RegexOptions.IgnoreCase)

cheers

[RACHEL_PAUL]

Thanks for your response.

Incase i have a sentence
Eg: “HAUL FIBRE AVAILABLE”

someimes there is unrequired space between them or no space.
How do i write my if statement then?

[Anil_G (Anil Gorthi)]

@RACHEL_PAUL

In the above expression change the mobilisation part to this

"HAUL\s*FIBRE\s*AVAILABLE"

System.Text.RegularExpressions.Regex.Match(str,"HAUL\s*FIBRE\s*AVAILABLE",RegexOptions.IgnoreCase)

cheers

[RACHEL_PAUL]

Hi Anil

In which Activity do i write this?

System.Text.RegularExpressions.Regex.Match(str,“HAUL\sFIBRE\sAVAILABLE”,RegexOptions.IgnoreCase)

[Sudharsan_Ka]

HI @RACHEL_PAUL

Use this expression in the if condition directly

System.Text.RegularExpressions.Regex.IsMatch(Inputstr,"MOBILISATION:NO|MOBILISATION:\s+NO",System.Text.RegularExpressions.RegexOptions.IgnoreCase)

Hope this Helps!

Regards
Sudharsan

[Anil_G (Anil Gorthi)]

@Anil_G

System.Text.RegularExpressions.Regex.Match(str,"HAUL\s*FIBRE\s*AVAILABLE",RegexOptions.IgnoreCase)

@RACHEL_PAUL

Please use it in if condition

System.Text.RegularExpressions.Regex.IsMatch(str,"HAUL\s*FIBRE\s*AVAILABLE",RegexOptions.IgnoreCase)

Cheers

[Sudharsan_Ka]

@RACHEL_PAUL

@RACHEL_PAUL

Incase i have a sentence
Eg: “HAUL FIBRE AVAILABLE”

someimes there is unrequired space between them or no space.
How do i write my if statement then?

same as above directly in if

System.Text.RegularExpressions.Regex.IsMatch(Inputstr,"HAUL\s+FIBRE\s+AVAILABLE|HAULFIBREAVAILABLE",System.Text.RegularExpressions.RegexOptions.IgnoreCase)

[RACHEL_PAUL]

What does\s* mean or \s and also this symbol ‘|’?

[kali]

RegExr: Learn, Build, & Test RegEx

[Sudharsan_Ka]

\s - will match the spaces

\s+ or \s* - multiple spaces

| - This is the Or symbol

@RACHEL_PAUL

Regards
Sudharsan

[RACHEL_PAUL]

Thank you it works !

[Suvam_Gupta]

Hi Sir
Can you say
how to taking date from excel and finding the previous date in UiPath