See example database and screenshots
--Need to create 10 new fields that parse data based on calculations using text functions and parsing the data from these 14 sample records.
--The format might be different in each record to be sure to test them all.
--There should not be any extra spaces on before or after the parsing because they will be used for a relationship later.
--Parse from the Text Field
--Coloring is not needed, that was just to show you an example of what we want
From Subject Field
Create 5 new calculation fields with the following data parsed dynamically
Subject Type: New Service Ticket
Subject Ticket Field: 201712280022213 (From Subject)
Subject Site Field: City Of XYZ
Subject Resource Field: PDSERVER
Subject Topic: (Shadow Protect Backup Job Failed at Site -City Of XYZ / Resource -PDSERVER (PDSERVER))
From Text Field
Create 6 new fields for text parsing
Text Ticket Field: 201712280022213 (From Subject)
Text Site Field: City Of XYZ
Text Machine Field: PDSERVER
Text Partner: Pure Solutions
Text Resource Field: PDSERVER
Text Body: Everything below the partner line.
February 23, 2018
I am looking for freelancers with the lowest rates