Removing word

Help Activities
, ,
1

Hi team,

I have an input like
Input 1 : THE MISSION IMPOSSIBLE
Bot should check the first word is if it contains ‘THE’ so it has to remove the word ‘THE’ and output should be - MISSION IMPOSSIBLE
Input 2 : THE THE THE MISSION IMPOSSIBLE
Output should be - MISSION IMPOSSIBLE
Help needed with sample code.

1 Like
2

grafik

1 Like
3

Using regex for a later replace (Regex.Replace)
Search for THE’s which are on Start of line / Text
grafik

4

Can you bit be more elaborate on this as i am new to this. I need to to use activity Match and then Replace? need step by step to understand

5

grafik

Use an assign Activity
LeftSide = strCleansed
RightSide: Regex.Replace(strText,Pattern,“”).Trim()

Ensure following:
grafik

1 Like
6

The above given solution is working fine only when the word THE is mentioned in caps. It should work irrespective of the input is in caps or in small characters.

1 Like
7

simple use replace its verry simple
input Variable.tolower.replace(“the”,“”).tostring

8

Sorry for the changes…
The above given solution is working fine only when the word THE is mentioned in caps. It should work irrespective of the input is in caps or in small characters. How to edit in the current code - RightSide: Regex.Replace(strText,Pattern,“”).Trim()

9

use my code above it will work

10

Use Regex.Replace(strText.ToUpper(),Pattern,“”).Trim()

11

@Chetan
Input : THE THE MISSION THE IMPOSSIBLE
Output should be : MISSION THE IMPOSSIBLE
Your code removes THE whereever it is found in the line.
It should remove only THE found initially as mentioned in above example.
Also same for the word AND also. Word AND also should be removed.

1 Like
12

Use this Code below
Variable.tostring.toLoweCase.replace(“the”,“”).replace(“and”,“”)

If get the solution please mark it as solution

Regards
Chethan P

13

If input like this use regex because u need the in between mission the impossible
Regex.Replace(strText,Pattern,“”).Trim()

and use replace variable.tostring.tolower.replace(“and”,“”)

14

Regex.Replace(strText,Pattern,“”).Trim()
and use replace variable.tostring.tolower.replace(“and”,“”)
If i use the above code 2 cases are getting failed

  1. THE the AND THE MISSION THE IMPOSSIBLE
    Expected Res: MISSION THE IMPOSSIBLE
    Actual Res: the MISSION THE IMPOSSIBLE
  2. THE the THE MISSION the and IMPOSSIBLE
    Expected Res : MISSION the and IMPOSSIBLE
    Actual Res: mission the impossible
15

Hi @Balan

image
image1178×589 108 KB

check this regex pattern

1 Like
16

Use this code

image
image1008×568 18.4 KB

StringData=“THE the AND THE MISSION THE IMPOSSIBLE”
StringData=StringData.ToUpper.Substring(StringData.IndexOf(“MISSION”))

Definetly you will get ok it was very simple code use this you will get

regards
Chethan P

17

@Nived, not yet tried this code. This - MISSION THE IMPOSSIBLE wont be static any words will be there.
Question is any lines starts with
THE
THE THE
AND
AND THE
What ever the no of times or combinations of AND, THE comes it should be removed only should be retained including AND THE

18

Hi @Balan,

Try this code:
Regex_Remove.xaml (4.6 KB)

Regex:
regex

Thanks!

2 Likes
19

@Kadiravan its working as expected. Thanks.
@Chetan, @Nived and others thanks as well…

2 Likes
20

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.