I am importing a text file. The text file only has one field called Request. Does anyone know a way that I can take this data and create a table with fields for each line.
This is how the file import comes in:
Request
*Report Request: 9557*
Date Submitted: Feb 1, 2017
Date Updated:
Date Needed: May 31, 2017
Technican:
Date Checked Out:
User Name: jsmith
Email: jsmith@abcde.com
Phone: (555)123-4567
Division: Northen Division
Work Unit: Leasing
Also Send report to:
File: 64576
Project Name: POINT COM DEVELOPMENT SITE
Report Scope: Full Report
Report Type: General
Concerns: Full Report for Point com development site lease
I want to convert it into a format like this:
ReportNum DateUpdated DateNeeded Technician DateCheckedOut UserName
4315 5/25/2017 5/31/2017 jsmith jsmith
Any help greatly appreciated.