Hi All,
i am importing data from our system, the field i am using is a combination of data, such as registration number, document number and description
I want to separate the fields data in to usable data.
I managed to extract the Registration
the next data i need is the document number. I used below code, it start is correct but it does not cut off as required, it displays all the data after the required cut off point
any suggestions?
the query contains 3 tables
Sample Data: ZS-RPB(30551)Sliding door handle mechani
Registration is "ZS-RPB"
Document number is all between the brackets: 30551
After Bracket is the description
i am importing data from our system, the field i am using is a combination of data, such as registration number, document number and description
I want to separate the fields data in to usable data.
I managed to extract the Registration
the next data i need is the document number. I used below code, it start is correct but it does not cut off as required, it displays all the data after the required cut off point
any suggestions?
the query contains 3 tables
Sample Data: ZS-RPB(30551)Sliding door handle mechani
Registration is "ZS-RPB"
Document number is all between the brackets: 30551
After Bracket is the description
DAW No: Mid([IW49 - Line Items TBL]![Opr# short text],7,5)