How to identify "<space>jr or Dr or , jr or II or III in names and replace them. any specific methods or using regex pattern?

Help Studio
, ,
1

For example , How to identify "jr or Dr or , jr or II or III in names like Gates II , Gates, jr and replace them. Any specific methods or using regex pattern?

2

assign this to a string variable

system.Text.RegularExpressions.Regex.Replace(oldName, "^([MDS]r|Ms)\.|(\s[IVX][IVX]+)|(\sjr)", "")

where oldName = your name containing Mr/Dr etc…

image
image765Ă—243 11.3 KB

image

3

Hey, really appreciate your quick reply. Its working. However, if the name is like this “amber<,>jr” - need to replace <,> along with jr. also if the name is just “amber<,>jr” - need to replace ,jr. Is this achievable along with the above case?

Thanks !

4

you mean the name is like this:?

amber,jr

5

then use this regex

^([MDS]r|Ms)\.|(\s[IVX][IVX]+)|(,jr)

how about III, II etc…
is it
amber,II
or
amber II
?

6

like this amber,jr or amber,spacejr

7

use this

^([MDS]r|Ms)\.|([\s]?[,]?[IVX][IVX]+)|([\s]?[,]?jr)

image

8

Let me put clearly

Its like : Name,SPACEjr and Name,jr
NOT : NameSPACE,jr

9

yes it works with
name<space>jr
and
name<,>jr

have you tested it yet?
image

10

Yeah, its working as you said for nameSPACEjr and name<,>jr. But is it possible to put like this name<,>SPACEjr

1 Like
11

yes it works with amber<space><,>jr

image

12

Sorry for the confusion. it was amber,SPACEjr

13

try this @TrinadhB
^([MDS]r|Ms)\.|([,]?[\s]?[,]?[IVX][IVX]+)|([,]?[\s]?[,]?jr)

14

@jack.chan Thank you! for your help

1 Like
15

Hey, i have found that if name is like Varun V or Xareen X . its replacing even the first letters. Can you look into this?

1 Like
16

^([MDS]r|Ms).|([,| ][,| ]?[IVX]+)|([,| ][,| ]?[,]?jr)

17

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