copy specific range then paste to new field

[Orlando L.]

Hello,

I have a field which contains a unique numbering, for each entry, such as 123456-654321.

Which scripting parameters should I use to grab the first part (e.g. 123456) and copy/paste it into another field which is empty, and then do the same with the other part (e.g. 654321) and copy/paste it into another field which is also empty.

Each entry has a unique numbering combination, which basically has two parts tied with a "-", and I need to grab each of its parts and copy/paste it into an independent field.

please, any advise is appreciated.

Regards,

[Raybaudi]

Hi

I would use 2 calculation fields ( no script ).

[color:green]FirstPart

GetValue ( Substitute ( YourField ; "-" ; ¶ ) ; 1 )

[color:green]OtherPart

GetValue ( Substitute ( YourField ; "-" ; ¶ ) ; 2 )

[Orlando L.]

worked perfectly!

thanks,