IDEAScript Questions

Hello all,
 
I have been trying to sort a column from an excel file.  I have a bit of code that is able to do number formatting as well as other formatting but I cant find anything that is for sorting.  The one thing that I did find wants to use Range and I am getting errors when I run the script.
 
Here is what I have so far.  I have also tried to use oSheet.Range.  Any help would be greatly appreciated.  Thanks!
 
Set oSheet = oBook.Worksheets.Item(1)

Hi,
 
I would like to create a new column out of another one. I have one column which contains text. For example an address. Now I want to replace certain parts within this string. For example I want to remove "AND". So replace "AND" with "".
 
 
So the field address contains "Road 1 and Plaza" and the new created field temp1 should contain "Road 1 Plaza".
 
I use the replace function mentioned here:
https://ideascripting.com/node/71
 

Dear Brian,
While googling I found the following code snippet on this website:
https://www.ideascripting.com/wiki/check-if-field-exists
It should be a code snippet that basically checks if a field exists or not. So I would expect that if that function returns true it does exist and if it returns false the field does not exist. However, the code snippet is wrong/misleading:
Set field = table.GetField(sFieldname)


Good morning everyone, I am trying to develop a script to export a file, but I get some messages like overwrite the existing file or adjust the columns of the pdf, I would like to know how I could add code to always select that If in the popups.
Thank you very much 

Hello,
 
thanks to the youtube tutorial i managed to create my first dialog box.
 
Depending on the selection, a script is started through the dialog box.
The selected script itself takes about 5 minutes to complete. It is possible to close the dialog menu before completing the selcted script and not afterwards?
Or maybe lower the showing level, it is allways the front window when i use other programs / windows.
 
 
 
thx for helping me
Torsten

Hello,
this is the first time i am writing in this forum, but i have already a lot of help from reading it. Now i m not getting any further.
 
It is best if i describe the problem first.
 
I want to split a database using the key extraction. Then i would like to create a pivot table, for example, in all the extracted databases. Since the database names can vary in number and naming due the keyfield extraction, a loop that runs through all files with the prefix of the extraction made sense to me.

All the rest of the code that loads the current IDEA base being analyzed and converts an IDEA database to excel works. As well as opening the page to send email. But this part of the code is not working, that part would be responsible for automatically forwarding the email.  
 
'With OutlookMail, from that point "To" command, "CC", BCC, Subject, Body, Send dont work.
 

Hello Everyone
 
I hope all is well.
 
May you please help if you have a solution around this? I know this was a covered on the below link, however, using the IDEA functions (@Left,@Right,@Split, @Simplsplit, @Mid, @JustNumbers) described, do not work for my currect situation. There are a lot of characters and segments, so trying to use IDEA functions is not effecient:
https://www.ideascripting.com/forum/text-columns-idea
 
Here is my current situation:

Hey IS Forum!
Right now I'm trying to solve an issue I faced while using one of my macros that I made a while ago.
Purposue of my macro is perform some tasks regarding appending new columns in files that have to work with on a daily basis.
 
Lately, unfortunately, instead of one file there are several files that I receive for analysis event though it is the same in terms of its content.
I know that I can append them and run the macro but there is some specific issue that i think when resolve on my end would be able to help in my future work.

Greetings.
I am new to ideas, and I have found this forum, which has helped me with some scripts; congratulations to the creator.
 
I have used the routine of executing scripts that were created previously, these are divided into projects and at the same time they are programmed for initial at a certain moment, this comes from versions prior to 11.2 which is the one I currently have, because of this there is a script that does not they execute me.