General discussion
Import of records in IDea
Forums
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
- Read more about Import of records in IDea
- 1 comment
- Log in or register to post comments
import table with odbc from IDEA
Forums
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?
- Read more about import table with odbc from IDEA
- 3 comments
- Log in or register to post comments
Error trying to import table from IDEA with multiple tables
Forums
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"
rename or rename the fields of a table
Forums
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
- Read more about rename or rename the fields of a table
- 6 comments
- Log in or register to post comments
automatically send mail in IDEA.
Forums
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?
- Read more about automatically send mail in IDEA.
- 4 comments
- Log in or register to post comments
Validate ID or identity card of 11 characters
Forums
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?
Replacing Whole Words Only using @replace
Forums
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"
- Read more about Replacing Whole Words Only using @replace
- 3 comments
- Log in or register to post comments
IDEA Limitations
Forums
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!
- Read more about IDEA Limitations
- 1 comment
- Log in or register to post comments
I recently placed a menu on the ribbon custormerize Ribbon
Forums
Hello everyone.
I recently placed a menu on the ribbon custormerize Ribbon that calls different macros, it happens that everything worked perfectly, but when I installed another laptop, it decides to go back again to recreate my menu, that is, install it again on the ribbon, but now every time I run a menu option, it throws an error: invalid macro name. When I go to the error line within the macro, this line is blank, and so for each menu option, always the same error.
That could be happening?
Trend analysis II
Forums
I test exceptions where i get results on a daily basis. These exceptions vary on various days. For example ivoices that were not taxed
I get these results in IDEA daily.
Monday i have a list of 9 invoices
Tuesday 15 invoices
wednesday 70 invoices
How would i go about showing this trend analysis based on daily results? Trend also can be based on monthly.
- Read more about Trend analysis II
- 6 comments
- Log in or register to post comments