Find Exact word

[msalesforce777]

Hello Team,
I want to find exact word in sentence,

eg : AV, AVE,AVENUE
Sentence: 2687 AVE 90

I have to replace AVE with AVE#,
Please guide

[NIVED_NAMBIAR (NIVED N)]

U can use replace function in string to replace the AVE with AVE #

like string_var= 2687 AVE 90

string_var.Replace(“AVE”,“AVE#”)

Regards

Nived N

Happy Automation

[Adrian_Star (Adrian Starukiewicz)]

Hi, see my topic and check the possibilities:

How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Hi, if you are a beginner in the world of automation and would like to know how you can manipulate text based on the solutions available in the VB.NET code and using REGEX (regular expressions) then you are in the right place. In the topic below, you will learn how to easily extract data from any part of the search text using various methods. The topic includes solution examples with descriptions and graphics to better understand the topic for functions such as: Split Substring Left Right R…

[msalesforce777]

Hey,

First i need to find out if the sentence contains exact keyword,
How can it be done ?

Thanks

[Adrian_Star (Adrian Starukiewicz)]

IF:
your_String.Contains("Word") (needs to be accurately reflected)
or
your_String.ToUpper.Contains("WORD") (convert text to uppercase and match to uppercase)
or
your_String.ToLower.Contains("word") (convert text to lowercase and match to lowercase)

[ksrinu070184 (Srinivas)]

@msalesforce777

Check as below to check

First use AVE in IF condition, In Else continue with AV and in Else continue with AVENUE

Hope this may help you

Thanks

[msalesforce777]

If i give input as “AV” then contains will be true in “AVE” Case,i need to exact match “AVE”, any suggestions

[msalesforce777]

There are almost 2000 records present, Cannot use if else to find and replace

[Adrian_Star (Adrian Starukiewicz)]

No worries. If your AVE has spaces around, add them to the condition. Like this:

[Yoichi]

Hi,

Can you try the following expressions?

Check

System.Text.RegularExpressions.Regex.IsMatch(yourString,"\bAV\b")

Replace

System.Text.RegularExpressions.Regex.Replace(yourString,"\bAVE\b","AVE#")

Regards,

[Pravin_Patil1 (Pravin Patil)]

IF word is going to be anything from AVE, AVENUE then use below…
If it can be AV also then just remove E from AVE in given regular expression

[msalesforce777]

This will work if only “AV” is present, how can i check a exact word in sentence

[vignesh.ks]

Hi @msalesforce777

Please try the below method.

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation

[Yoichi]

Hi,

How about the following?

Check:

System.Text.RegularExpressions.Regex.IsMatch(yourString,"\bAV\b|\bAVE\b|\bAVENUE\b")

Replace:

System.Text.RegularExpressions.Regex.Replace(yourString,"\bAV\b|\bAVE\b|\bAVENUE\b","AVE#")

Regards,