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,
Ok, you got the result.which is the right answer click there "Correct answer" then close your question
View solution in original post
HI ,
The above code is used to replace the ' - ' value by the null() value .
Basically some DataSource may contain '-' value instead of null values .
The Field Originatingcompanymnemonic might be containing '-' instead of null
so this expression is used to replace the '-' with the null() values.
Regards
Yusuf
Thank you very much Yusuf for your prompt advice! Would you be able to advise further what does the below statement do please:
(Left(Originatingcompanymnemonic, if((findoneof(Originatingcompanymnemonic, ' '))=0, (len(Originatingcompanymnemonic)), findoneof(Originatingcompanymnemonic, ' ')-1))
Perhaps I can call you to have a quick chat?
What is the above statement trying to do please?
Hi Yusuf!
Thank you for your prompt advice!
Would you kindly advise what is the below statement trying to do pls?
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/>
Send Some Sample data for Originatingcompanymnemonic .
This field type of data are contain.
Here you go..
It is trying to find the ' ' ( space in the field value string) .
If there is space it remove the text after the space .
For example If you consider a fieldvalue "Amer ca" this is the text then it will consider only "Amer" .
Hi Yusuf,
Thanks again for that.
Possible if I could have a quick call with you on this please?
Thanks very much!
