I'm trying to conver the following item number into a regular expression: 04-048988, the first two number is for the year and the last six is the number assign by the system. I want to output the value into the global sheet.
Format I use is [0-1][0-4]-[0-9][0-9][0-9][0-9][0-9][0-9] but I get the following run error:
The item number object's desc matches more than one of the object currently displayed in your application. How can I make it just read one line at a time.
My next option is just picking up the number from the source, since the item number is a link.
Thanks in advance.