Counting while..

Hi noamh and welcome to the site.

Actually this is one that I get asked fairly often so I have put together a script to do this. You can find it here: http://ideascripting.com/ideascript/add-counting-column

Let me know if you have any comments or problems using it.

Thanks

Brian

Hi noamh,

That is interesting.  I created a test file that was similar to yours:

I ran the script.

Thisis what I got.

Now one thing I forgot to add to the script is you need to close the file and reopen it to view the count field properly.

I just noticed something, are you running this on a virtual field?  If so can you recreate the field as an IDEA field, so when creating the field select Character instead of virtual Character.  The problem is virtual character fields stores the formula and not the results but we want to do this on the results.  I will update the script to add a warning about that or maybe to filter out virtual fields.

Thanks

Brian

I added some code to exclude virtual fields from being selected and added a warning to the dialog. 

Hi Noamh,

First you create the IDEA Character Field using the Field Manipulation.  The field length should be the same as the virtual file.

Then click on parameter and just enter in the field you want to copy, in my case the virtual field.

click on validate and exit and then exit and you should have your new field.

Let me know how this goes.

Brian

Hi noamh,

This is strange.  Any chance you can share with me the parts of the file, such as the two fields that create your virtual field so I can try and understand what is going on.  I am wondering if it is a problem between my ASCII version and your Unicode version.  The problem is the script seems to work fine for me. 

If you want to share it you can email me at brian.element@ideascripting.com.

Thanks

Brian