Suggestions for IDEAScript snippets

 
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"

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

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:

how to open the wizard by code?
 
thank

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

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

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).

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

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

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