How to use 'Mid' for front and end characters simultaneously

[vsap2000]

Hello Friends,

I have a  Order #  field which can be any length in that field if the  first 3 char is number 252-0750-060060, 252-0200S than it should be 'Order Comp' and now tricky part, in that field if you have 6194-31459-2520, WR245977-2520 it should say 'Order Incomp'. From the different position of 252 number in Order # filed it gets the Order Status Flag. 

For the initial part I was able to get If (Mid(Order#,1,3) = '252','Order Comp') but how to add other piece for that I need your guys help.

Thanks in Advance!

-V

[Digvijay_Singh · Accepted solution]

May be like this - 

if(left([Order #],3)='252','Order Comp',

if(substringcount([Order #],'252')>=1,'Order Incomp')) AS [Order Status Flag]

[Frank_S]

Are you trying to 'split' your field?
If so, this is possible using the 'Split' card in the Qlik Data Manager

• https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/LoadData/splitting-a-fiel...

Hopefully that points you in the right direction. If not, hopefully others here will offer their insight.

Kind regards

[vsap2000]

It worked. Thanks!

[Digvijay_Singh]

I am glad it helped!