Questions on Custom Functions

Hi,
I have two databases, the first one contains a series of columns with data, the second one contains several words. I need to perform a search on specific columns of database 1  that contain the key words in database 2 
Sample: Refer to image attached. 
I can't use the search function as I have more than 10 key words to be search 

Hello. Usually we use subquery when we want to include the values from a secondary table to select a resulting recordset from a principal table. So, I need to do this in a ODBC connection, i have to import info from a primary table using subquery from  an IMD file(Idea Database). Is it possible? Does anyone have an example t share, plese?

Hi guys,
I'm currently working with date field where I need to determine whether the particular date is either weekday or weekend. I'm able to do that with the @workday(date) function. However, I'm facing difficulty to group that result by week. E.g 04.01.16 to 10.01.16 (1st week in Jan 2016), 11.01.16 to 17.01.16 (2nd week in Jan 2016). My 1 week here starts from Monday to Sunday. 
My task is after the grouping of the date by weeks, I need to extract those transaction that is more than 3 times in a week.

Hi everybody,
I know that this thread is for custom functions, but I did not find a thread for the built - in functions.
I'm having some difficulties in using @Isini function.  Using the syntax provided by the equation editor < @Isini(''Co'', SUPPLIER) > on a character field I'm getting an error with the message "syntax error". Any ideas / suggestions?
Thanks,
Cristian Gradinaru

G'day All,
Recently, I got a request to do a search or comparison between field names/columns in a same IDEA database files. Refer to example below, I need to search the word apple in column 2 from column 1. What is the @function that could be use here or do I need a script to do that?
Column1            Column2
1. orange          1. banana
2. apple           2. mango
3. pear             3. peach

Greetings,

Hi there,
I have a file where my task is to extract and flush out the duplicates with 3 columns in IDEA. Any chance of how to do that? I try use @compif, @list and @match, but the result is not what I'm expected. Here's the scenario:

 
Col1
Col
Col3

Row1
1
0
0

Row2
2
2
0

Row3
3
0
3

Row4
4
4
0

Row5
5
0
0

Hi,
I'm currently working on an automation to calculate ratios in IDEA. How am I going to perform "divide" in certain row in IDEA with another row.
Here's the scenario:
      Item (Type: Char)                 Amount (Numeric)
1.   Margin A                                           20

Hi,
In IDEA ver 8, I could see and use custom function in all IDEA projects by importing function I previous built and saved. In IDEA 9 I haven't button "Import" in Custom Function screen. Does anyone know if there is any way to post function for all projects in IDEA 9?  
Thanks,
Shlomit

I am sure there is a way but I have forgotten how to do it.  I know for IDEAScript you put the i before the function but does the custom function have this option?  I thought it did.