Suggestions for IDEAScript snippets
Suggestion for useful functions that could be inserted into an IDEAScript
How to cut a string into individual words
Hi,
maybe someone needs something like this.
Here is a short Example:
Sub Main
Dim sOriginalText As String
Dim sOriginalText_C As String
Dim sWord As String
Dim iNumBlank As Integer
sOriginalText = ""
sOriginalText_C = ""
sWord = ""
iNumBlank = 0
sOriginalText = "42 : , ; .. How many roads must a man walk down Before you Call him a man How many seas must a white dove sail Before she sleeps In the sand"
- Read more about How to cut a string into individual words
- 3 comments
- Log in or register to post comments
Data Input by user
I'm trying to add a field to an existing database with a run date keyed in by the user
I'm getting the following error "Error on line 26 - type mismatch"
Does anyone have the answer - The code is as follows:
Sub Main Call TestFunc2() ' Test different coding examplesEnd Sub
- Read more about Data Input by user
- 4 comments
- Log in or register to post comments
Date Picker
I just added a date picker to the snippet section. One limitation of the IDEAScript dialog is that there is no date picker. I had recently seen a comment on the IDEA forum that they had a script for one but for whatever reason had not posted it in their script section. So I decided to try and create one of my own. I think the final product is not bad:
- Read more about Date Picker
- 2 comments
- Log in or register to post comments
import assitent
how to open the wizard by code?
thank
- Read more about import assitent
- 4 comments
- Log in or register to post comments
Checking for a list of charcters in a string
I just added a new snippet to the library. This one will check if a list of characters are present in a string and will return true if they are.
http://www.ideascripting.com/snippet/checking-list-charcters-string
- Read more about Checking for a list of charcters in a string
- Log in or register to post comments
Using listboxs to select files/fields
I just added a snippet that shows how to create a dialog with two listboxs in which you can list and select files or fields (or any other type of list for that matter).
http://ideascripting.com/snippet/using-listboxs-select-filesfields
- Read more about Using listboxs to select files/fields
- Log in or register to post comments
put the puzzels together
hi folks,
i will show you how to put the iss puzzels together..well most of you will already done this, but for the new ideascripting folks it
is maybe a inspiration...
if you work each time with the same datastructure i show you how to import csv files automatically into idea and how to organize
some of your scripts in a comfortable way...
in this example i have one masterfile and two detailfiles. the file are from type csv. of course you need for every datafile
a record definition file (rdf).
- Read more about put the puzzels together
- 3 comments
- Log in or register to post comments
text cleanup
what does the script do?
you can choose a idea table from your working directory and than choose a char column from this table.
the script will create a new column (you have to give it a name and datalength) in the table.
the new column is prepared according to a self-assigned formula.
maybe the dialog e.g. could be extended with option buttons for different formulas...
in the example a very easy formula is used...
happy coding...
chris
- Read more about text cleanup
- 2 comments
- Log in or register to post comments
get error messages or notes persistent
if you are testing macros in idea or if a macro is rolled out you maybe want
error messages an things like this persistent.
also if you have messages in your script that should inform the user what is going on
you maybe do not want a showstopper like a msgbox...
so just try something like this:
@brian:
-------
please format the code ;)
main
----
Sub Main
'declaration
Dim a As Integer
Dim b As Integer
a = 0
b = 1
- Read more about get error messages or notes persistent
- 2 comments
- Log in or register to post comments
Actionfield with IdeaScript
and again...
Actionfield is a really nice toy to play with...
here is a short example
Sub Run_Actionfield
'declaration
'-----------
Dim sTableActionfieldMaster As String
Dim sTableActionfieldDetail As String
- Read more about Actionfield with IdeaScript
- 12 comments
- Log in or register to post comments