Task summary - Toppan Photomasks, Inc.

Input: Test_data.xlsx Output: We need to read and make all the data suitable for automation

Proposed Approach:

1.   Read the data from excel
   

2.   Parse excel using libraries, regular expression, etc
   

3.   You are free to use object-oriented concepts as well as a simple procedural approach
   

4.   All the data & sub-data should be accessible field wise
   

• E.g., “Part Ref” should be displayed as something like
• Part ref: PR 190444 LOT90 333 3434FDGG
• Subpart1: PR
• Subpart2: 190444
• Subpart3: LOT90
• Subpart4: 333
• Subpart5: 3434FDGG

Notes

Our development stack is mainly on Python and Perl; hence we can evaluate faster in those cases. However, you can use any language, like Python, Perl, TCL/TK, Java, C, C++, etc., to solve the task. Tip: If you plan to use open-source libraries, please ensure it is well maintained and have regular releases. Confidentiality: Please don’t share or upload the data or assignment anywhere Submission: Please use only your GitHub repository to submit the solution and share it within one week of receipt of this email.