Some string error in function, object no defined.

[hellind]

Why am I getting the error in this function: CustomSplit

Please see attached database. Try to query [query_dt_volume1]

It is simple query, calling the function in module: CustomSplit.

Output should be:
Tower Records [USA] = Tower Records
Deutsche Bank [Hong Kong] = Deutsche Bank
HongKong Fund = HongKong Fund

Any assistance much appreciated.

 

[jdraw]

I looked t your database after reading your post.
From a database perspective--every table should have a primary key.
Your CustomSplit function is all comments??? Why?

When you post a question, give some descriptive information to help put the question and you into context. An overview of the business issue or opportunity in simple terms indicating what you are trying to accomplish is very helpful.

If there is a common format to incoming records, then identify same with examples.
If, as in your case, there is a custom function, then tell readers about the function. What is the purpose? A brief description of the logic in plain English is helpful. A sample execution of the function--this was input and these are the results.

I understand how you can process a string
eg Tower Records [USA] to get a final string of Tower Records

I do not have any idea of what your database is about nor what you are trying to accomplish.

I realize you have relatively few posts in the forum, but you have been a member for 7 years. So this isn't the first time you have posted, or read through forum threads.

You might want to edit your post and adjust it to clarify the issues you are facing..