This content has been marked as final. Show 6 replies
Good day. Trying to join some information based on fields that are not unique. So what would the script be to separate it out.
162.3. Where everything before the first period is what I want to call Task List ID. Everything between the periods I want to call Task Number.
So I want to separate based on the periods. The two files are Excel so when I load the files. This field comes in as xls. rather than delimited type.