Split remove and trim

Learn Academy Feedback
1

Hi want to remove Mr. and space like this name
pls help me
Mr. Anandhan Ramamoorthy

2

Can you be more clear with what you have and what you want it to be ?

3

Hi,
thanks for quick reply
i have data like this
Mr. AKASH KUMAR
Pankaj kumar Vasudev vishwkarma
Mr. HARICHARAN
Mr. PRADEEP KUMAR
RAVINDRA

but i dont want want mr, dot and space after mr. only i need name
like this
AKASH KUMAR
Pankaj kumar Vasudev vishwkarma
HARICHARAN
PRADEEP KUMAR
RAVINDRA

4

For each name
If Name.ToLower.Startswith(“mr.”)
{
Name.Substring(3,Name.length-3).Trim.Replace(“.”,“”)
}

5

Thanks @GSR
i am trying

7

Thanks a lot its working fine
@GSR

8

Cool. Please mark it as complete if it solved your case. This will not confuse others.

9

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