General discussion

When applying criteria IDEA freezes at 0% with any file.  I imported a tiny 3 row, 2 field test file.  I set a criteria and it worked ok.  Then if you close and reopen the file it just sits at 0%.  IDEA is being run from a local drive (not network) and i have full permissions on the location. Any ideas?

Hi!
I'm looking for a script that would append additional column into my ile with values equal to source file name.
In my example I have text files e.g.  20230831.txt with one column of data.
I would like to import this file into IDEA and have to column of which one would store in every field value "20230831".
If there would be a way to import multiple file this way at the same time that would be excelent! :)
 
Thanks in advance for the help!
Regards,
Maciej

Hi,
 
I am importing a text file which has 32 lakh records but upon import idea shows only 16 lakh records. 
 
Can someone help me what could be the reason. System has enough space

I am trying to import a table with today's date, that is, current. but it throws an access denied error on line 8.
example
Sub Main
 Call ODBCImport()
End Sub
 
Function ODBCImport
' para esta tabla rango de fecha para tomar el balance que quedo. 
dbName = "Devengo.IMD"Am I not doing it properly?

It only tells me an error on line 9, but it does not specify the error that it is.
 
Sub Main
Call ODBCImport()'
End Sub
 
 
' Archivo -Asistente de importación: ODBC
Function ODBCImport
dbName = "FISA.TCLI_CLICTA.IMD"

greetings,
How can I change the names of the fields in a table to be able to export it in excel. Is there any script that can help me.
Thank you

Hello, Does anyone have a macro to send automatic mail in IDEA.I am carrying out several daily test extractions, I must send the result by email in Excel, of course after exporting it, but I want to do it automatically, without going into each Excel generated and manually sending it from IDEA.
Do you have something out there that you can enlighten me on?

Greetings to all,
How can I make a script in IDEA to validate the ID or identity card of all the Bank's clients? Any ideas?

Hi All!
 
I'm trying to use @ replace to clean up a big Vendor Liost by replacing some common Company Names with "" (essentially removing the bits I don't want).
 
When I use Add Virtual Charachter and the parameters below, it removes parts of words, as well as whole words. How can I tell IDEA to replace Whole Words Only?
 
@replace(@replace(@replace(@replace(SUP_NAME, "CO", "" ),"AS", "" ),"AGENCY" ,  "" ),"AGENCIES" , "" ) 
 
In this example above "DALLAS COUNTY AUDITOR" becomes "DALL UNTY AUDITOR"

Hi Brian,
is there a limit how many cases a @compif function can handle or is there a a limit for the length of an equation?
Thanks in advance!