Function or Script
Forums
Hi All,
I have a field that contains a list of number separated by (,), what i need is : create a lot of field depended of how number contained in it ,
for ex : 3554249, 3554250, 3554251, 3554252 and the result that i'd like is for ex :
A
B
C
D
3554249
3554250
3554251
3554252
Thank you.
Just a couple of questions.
Just a couple of questions. Did it create any additional append files or did it give you the erorr on the first extract? Second question is all your fields character except for the rate field? The equation is assuming a character field so if one of your number fields is numeric that would give you this error.
Hi Brian,
Hi Brian,
First point; the script work correctly and yes for the error it was related to the type of field and I changed it from numeric to character. Seconde point; is, I split the database in 3 parts due to the performance of my computer and i was asking if is it possible to add for "Clientclose" after creating each field ?. Last point; that is related to my fault, is I forget to tell you that the field 'Rate' is in position 2 and there another field named 'Country' is in the first field so i would like to include it in the result.
Thank your very much for your helping.
Regards.
Hi Ahmed,
Hi Ahmed,
In the latest script do you see these lines in the extractFields() function:
task.AddFieldToInc sFieldNames(0)
task.AddFieldToInc sFieldNames(1)
task.AddFieldToInc sFieldNames(i)
If you don't then you are still using the old script. Let me know.
Thanks
Brian
Hi Brian,
Hi Brian,
I execute the script following your recomondation and i get this error message
Thanks.