Logic....

[tmumaw]

Anyone see anything wrong with this:

if(mid(MntPlan_WARPL,1,5) = 'PMH/J',mid(MntPlan_WARPL,1,5),

   if(mid(MntPlan_WARPL,1,5) = 'PMC/D',mid(MntPlan_WARPL,1,5),

      if(mid(MntPlan_WARPL,1,3) = 'PMN',mid(MntPlan_WARPL,1,3),

         if(mid(MntPlan_WARPL,1,3) = 'PML',mid(MntPlan_WARPL,1,3),

           if(mid(MntPlan_WARPL,1,3) = 'PMA',mid(MntPlan_WARPL,1,3)))))) as PM_Type

Thanks

[Digvijay_Singh]

Looks fine to me syntax wise. What error you are facing?

[Clever_Anjos]

No visible issue.

What is being returned?

[Anonymous]

Hi Thom.

Seems good to me. What are you trying to achieve and what are the errors you are facing here?

[tmumaw]

PMA only is being returned

[Clever_Anjos]

It would be possible if you post a sample of your data?

[Anonymous]

Hi thom,

I'm thinking maybe this is what you are trying to achieve?

if(MID(MntPlan_WARPL, Index(MntPlan_WARPL,'PMH/J'), 5) = 'PMH/J','PMH/J',

if(MID(MntPlan_WARPL, Index(MntPlan_WARPL,'PMC/D'), 5) = 'PMC/D','PMC/D',

if(MID(MntPlan_WARPL, Index(MntPlan_WARPL,'PMN'), 3) = 'PMN','PMN',

if(MID(MntPlan_WARPL, Index(MntPlan_WARPL,'PML'), 3) = 'PML','PML',

if(MID(MntPlan_WARPL, Index(MntPlan_WARPL,'PMA'), 3) = 'PMA','PMA',)))))  as PM_Type

[Anil_Babu_Samineni]

Might be this

if(mid(MntPlan_WARPL,1,5) = "PMH/J",mid(MntPlan_WARPL,1,5),

   if(mid(MntPlan_WARPL,1,5) = "PMC/D",mid(MntPlan_WARPL,1,5),

      if(mid(MntPlan_WARPL,1,3) = "PMN",mid(MntPlan_WARPL,1,3),

         if(mid(MntPlan_WARPL,1,3) = "PML",mid(MntPlan_WARPL,1,3),

           if(mid(MntPlan_WARPL,1,3) = "PMA",mid(MntPlan_WARPL,1,3)))))) as PM_Type