May 29, 201015 yr Newbies 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,
May 29, 201015 yr Hi I would use 2 calculation fields ( no script ). [color:green]FirstPart GetValue ( Substitute ( YourField ; "-" ; ¶ ) ; 1 ) [color:green]OtherPart GetValue ( Substitute ( YourField ; "-" ; ¶ ) ; 2 )
Create an account or sign in to comment