I'm trying to get from the excel file the file name except .jpg portion of it.
SUBSCRING('123-456.jpg', 1, LEN('123-456.jpg') - 4)
But the execution result is FUNCTION LEN does not exist.
Does that need to be added to the StoreManager SQL library?
Actually, we don't work with custom application like https://msdn.microsoft.com/en-us/library/ms190329.aspx , we use MySQL which doesn't support LEN() function .
We recommend for testing launch the following query in Custom SQL section of Store Manager - SELECT SUBSTRING('test string', LENGTH('test string') - 4) AS test .
I would like to share with you the following online document - http://dev.mysql.com/doc/refman/5.7/en/string-functions.html - it could be useful in such case.
If you need any assistance - let us know.
Sincerely, eMagicOne team
May 18, 2016
We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
Maybe we are waiting for some information from your side? In this case please get back to us.
In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.
If you do not reply us back, the ticket will be automatically closed within 24 hours.