Consider space for mapstring

[prashbhosale]

Dear all experts 

Need advise on below

I have company names coming in and need output as below

ABC P Ltd - - Private limited

LMNOP LTD - -  Public limited 

i. e. When it is P separate from other words then Private Limited and if it is part of other word then Public Limited 

I have applied mapstring but its working on only for first case and not other. 

Kindly suggest 

[micheledenardi]

Is there a particular reason why you're using mappings and not a simple wildmatch?

Load
if(WildMatch(CompanyName,'* P *'),'Private Limited','Public Limited') as CompanyType
From ....