Replace Text after keywords

Hi,

For example If I have a list of Keywords that I am checking against:

Keywords

DOB

USER NUMBER

PASSPORT NUMBER

I am doing a find and replace on a Description Field to see if these words exist. Is it possible to replace the text following a Keyword with "This text has been removed" ?

Many thanks,

Fiorano

Parse

Data Investigation

Accepted answers

CharlieS

@fiorano

For that solution, I used a combination of @LordNeilLord's Find/Replace solution and my RegEx solution. I used a universal placeholder for the RegEx that is updated using the Find/Replace method.

Solution attached.

20180619-ReplaceKeywordPhrase.yxmd

All comments

CharlieS

@fiorano

This is easily achieved using a RegEx formula. In a Formula tool use the following to replace the DOB cases:

REGEX_Replace([Field1],"DOB \<\w+\>","DOB This text has been removed")

The expression "DOB \<\w+\>" is identifying strings in [Field1] where "DOB " is followed by a string of characters. When that case is true, then "DOB " and the first subsequent string of characters will be replaced with "DOB This text has been removed".

Using the above formula on this input:

DOB 19000101 PLUS SOME ADDITIONAL TEXT

This is the result:

DOB This text has been removed PLUS SOME ADDITIONAL TEXT

DOB \<\w+\> isn't the only way this can be achieved, but the expression will depend on the format of the information following the keyword. If the string following the keyword is only numeric characters then "DOB \d+" could be used.