Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Would anyone able to tell me what does the statement below do please?
if((Left(Originatingcompanymnemonic, if((findoneof(Originatingcompanymnemonic, ' '))=0, (len(Originatingcompanymnemonic)), findoneof(Originatingcompanymnemonic, ' ')-1)))='-', NULL(), (Left(Originatingcompanymnemonic, if((findoneof(Originatingcompanymnemonic, ' '))=0, (len(Originatingcompanymnemonic)), findoneof(Originatingcompanymnemonic, ' ')-1)))) as MOC_OrgCoy,
Thank you very much for your kind advise!
Hi,
Yes really i appreciate .
But At present i could not take the call .
I can avaialble after 6 hours from now.
But still i can reply to your post .
Sorry for the inconvenience .
Regards
Yusuf
Hmm..6 hours will be my night time..around 10pm. If you can call me at 65-9108-4192, that would be appreciated much!
Otherwise, I just need to speak to someone in your team to guide me thru what does the statement do step by step..should be quick..
Thanks,
Jeremiah Lee
Product Manager for eWindow®, Global Trading Services
Platts
12 Marina Boulevard
#23-01, Marina Bay Financial Centre Tower 3
Singapore 018982
DID (65) 6530 6415 | Support (65) 6530 6530
Mobile (65) 9108 4192 | F (65) 6532 2700
Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>
www.platts.com<http://www.platts.com/>
Try this one.
Ex: if(len(Trim(Originatingcompanymnemonic))>0,SubField(Originatingcompanymnemonic,' ',1),Null()) as MOC_OrgCoy
Hi Kumar,
Would it be possible if I give you a quick call please?
Find the attached file.i think you are looking this type of syntex. Go to help(F1) there you can able to read about all the function
Got it, it is clear now.
I got a last advice request..based on your last statement..
if(len(Trim(Originatingcompanymnemonic))>0,SubField(Originatingcompanymnemonic,' ',1),Null()) as MOC_OrgCoy,
Some Originatingcompanymnemonic value is “-“ and I need to return a NULL for those records..how do I do it based on your statement above please?
try this
Ex: if(len(Trim(Country))>0 and Trim(Country)<>'-',SubField(Country,' ',1),Null()) as MOC_OrgCoy
It works!
Thanks very much Kumar!
Ok, you got the result.which is the right answer click there "Correct answer" then close your question
