How to copy a specific string from a column to another

Hi 

Tks i have tried it but it copy the everything from the column. I know why so here's what happen

the Line Expense Code:  has more info within the same line so heres an example of the line, cannot really copy and past the whole thing due to sensitive information..

--- Approval Information ---
Department: Department Name
Organization: Org Name
ExpenseCode, GL or Invoice: Expense Code (Division1) Expense Code: 12345678.98877.776655.444
GL Code:
COA Approver: approver email

So some scenario it would be Expense code and other would be GL as we have 2 Divsion.

right now it just copy everything to the new column. 

What you provided is exactly what i am looking for.

Hi 

Tks it is reallly appreciated. I will give it a try and update. Basically this is within Remedy via the DWP module. When a request for NewIT Equipment is send, they need to fill out a form which contains section like the following.

Approval Information

Request Information

Reques for information

Computer information

Monitor information

Software information

Peripheral information

Printer Information

Business Requirement/Rational

All of this have approx a total of 60 line all dump in one cell for each WO created.  At first we had requested for the to create a table to make it easier for us to handle but thats not what they did, its a dump in the ticket. Now What i am trying to do is basically extract the information needed to validate against our asset management. 

IF what you provided me work, i will adjust and export/add more column for the device information and other information. I try to think how can this be done differently but so far its the only way i can think of.

I will try what you provided and update you.

Tks again 

Hi how r u i try but this time the colum is blank no data i will check again and review. Here's the full detail which is fill out i remove all sensitive information and this is exactly how it is displayed in the table so basically each work order will have all of this information provided in 1 cell in the colum name DetailDescription. One thing is for each individual WO, its either  the expensecode or GL Code  as you will see in the approval information.

Tks

here's the information

--- Approval Information ---

Department:

Organization:

ExpenseCode, GL or Invoice: ExpenseCode Coding (Division 1)  ExpenseCode:  ExpenseCode

  GL Code:

COA Approver:

--- Requester Information ---

Request Contact:

Dept:

Branch:

Phone:

Email:

--- Request For Information ---

Active Account: Yes: They have an existing and active account

 New Employee Name:   

  Existing Employee Name:

Email Address:

Dept/:

Branch:

Building:

Office Location:

Street Address:

City:

Province:

Postal Code:

Phone:

--- Computer Information ---

Device Type Requested:

Requested Desktop:

Quantity:

Requested Laptop:

Quantity:

Requested Other Device Requirement/Rationale:

--- Monitor Information ---

Monitor Requested:

Quantity:

Other Monitor Requirement/Rationale:

--- Software Information ---

Asset Tag:

Software Name(s): ["~Other"]

Note:  If eSignature is requested, it will be provisioned on

Software Quantity comments: 1 of each software title requested

Other Software Information:

--- Peripheral Information ---

Peripheral(s) Requested:

  Computers and Accessories Requested:

  Data Storage Requested:

  Headsets and Earbuds Requested:

Keyboards and Mice Requested:

Speakers Requested:

Webcam Requested:

Other Peripheral Information:

Quantity:

  Quantity more than 1 Details:

Requested Completion Date: 07/18/2022

--- Printer Information ---

Onsite Contact Name:

Onsite Contact Email:

Onsite Contact Phone:

Special Location Notes:

Number of employees to use device:

Elevator:

New/Replacement:

  Replacement Make, Model & Serial/Asset: , ,

Requested Printer:

Printer Options:

Printer Options Details:

Local Connection:

Unique Software:

Business Requirement/Rationale:

Additional Information:

Tks it does work what i did wrong is the following

ExpenseCode, GL or Invoice: ExpenseCode Coding (Division 1)  ExpenseCode:  ExpenseCode

For division one  where it says Var _Code = ExpenseCode, GL or Invoice:"

by only copying this part it works, the question i would have is now i do have the code but i have the remaining in front of the code 

ExpenseCode Coding (Division 1)  ExpenseCode:  ExpenseCode 111111222333322211

Is there a way to only have the number

I did the same for GL Code, this one works as well and only show numbers. 

Tks again really appreciated and great work !