Tips and Hints

I recently saw this used in a script and thought it was pretty interesting.  It allows you to use a dictionary in IDEAScript which could be very useful.

Hi Brian, hi guys,
I am using this website since 2017 and it helped me a lot. Thanks a million! Since I have not found an answer yet I would like to post my question here. I am struggeling calling an IDEA macro from a VBA macro in Excel. I am pretty sure it is not that complicated and I will slap myselfe for not coming up with the solution . Can someone give me the correpsonding code snippet as example? 
Many thanks in advance and happy friday everyone! 
Dennis 

Buena tarde a todos estoy pensado en realizar prueban en el modulo de HCM y quisiera si alguien me puede dar ideas de algunas pruebas que ya hallan ejecutado en SAP agradeceria algunas ideas para ejecutar la pruebas y muchas gracias por la atencion.

Hi,
I'm using @isini to find the word "bar", however, it is bringing so many false positives (.i.e. "Barbara") that I would like to avoid. I remember having heard some tricks to solve this in one of the webinars, but I don't remember how and did not find my notes. Any suggestion?  

Hello,
 
I wasn't sure where to look for this task.  I have a database and it has 9 columns however, they are repeat column headers with their own sets of data.  For example,
 
Check Num 1     Date 1     Amount 1     Check Num 2     Date 2     Amount 2     Check Num 3     Date 3     Amount 3
 

I'm trying to break down the following equation so it can all be seen in the IDEA scripting window: 

I stumbled upon a (afaik) undocumented feature. The IDEA file explorer does not display IMD filenames starting with a dollar sign (e.g. $LEDGER.IMD). Nevertheless these files can be opened via IDEAscript.

Convert JDE 6 digits time field to proper time

I have access to a table in our accounting software package and I'm trying to download transaction from 10/1/2019 to the current date.  If I Import the table I get everything all the way back to 2006.  Is there a way once I've imported it to strip out extra dates and only get what I need before exporting to excel?  I'm in version 11.1.

How can you expand (duplicate, replicate, multiply) n times (tuples) each record on your database?
Example: From current situation to output required.
Current situation 
db.original (matrix [3x5])    

id_field

field1

field2

field3

multiplier_field

R39244

String1