IDEAScript Questions

I have a process that comes out of the smart analyzer that builds a what I will call a  base database.  Let's call it DB.  It then builds DB(1) DB(2) etc..  I want to programmatically concatenate then into one database.  The number of databases underneath the base is not the same.
 
I see two ways of doing it. 
 

I have a file that adds multiple user groups for a user into one column.  I am wondering if there is a way to split that cell into multiple rows so the user will show mulitple times with each individual group name.  I have attached an example of what I have and what I want it to look like.  Thanks!

Greetings,
What are the best practices for converting a Julian format date into a regtular dates?  From this YYYYDDD to this AAAAMMDDIf possible, I would like to get an answer that could be easily applied by a not very tech savvy user I am supporting.

Hi all. I am struggling with ideascript. I am trying to exclude certain default postcodes and when I have them within quotes it automatically tries to recognise AS as As. So when I search for postcode = "XX1 1AS" it changes it to postcode = "XX1 1As" it still does it when I try all @lower or @upper.
 

I am trying to accomplish the process described below.  I tried it by adding a new field to the master db and doing a database lookup on the wildcard table.  The lookup was successful but I was not sure how to get the value from the wildcard table to add to the new field.  I should have kept the code to post.  I believe I needed to get values from two tables but could only get them from one.
 

Hello everyone
I need some help. Does anyone know how to exclude duplicates from a table, for example by record number?
Thank in advance.
Elaine

I would like to ask the group for some help.
I have a very large table and I want to make an extraction of the most recent records. 
For example :
Vardate >= 01022023 
Vardate has an 8 digits.
Thanks

Currently I have the following interface (see attached picture).
My IDEA script is attached.
It is a simple code that allows the user to select a file. However, it uses the IDEA dialog to choose a file in the current IDEA directory.

Good morning,I'm new to the site but also to programming. I train myself on the creation of scriptIdea in order to automate repetitive tasks. Inspired by messages found on your site, I tried to develop the following script to 1) write information in a virtual field to determine unique records based on an ID and a date of action(oldest) see extract unique records directly into a new file. Nothing works. Despite

Hi IDEA friends!I want to add a variable to the script that can be set by the script user. 
Sub Main
...
 
Keyword1="test"
Keyword2="test2"
Keyword3="test3"
Keyword4=""
Keyword5=""
...
Keyword15=""
...
End Sub
 
The corresponding function:
Function Risk_Summary (Keyword1, Keyword2, Keyword3)
Set db = Client.OpenDatabase("XY.IMD")
Set task = db.TableManagement
Set field = db.TableDef.NewField
field.Name = "KEYWORD"