In standard object Case there is Description field and there is text being inserted i'm looking for specific text/string "First Name" and i would like to move everything from the left of "First Name" to a custom text field. Is it possible with using workflow and How?
To be clear, you want to move part of your Description field to another text field? Here are a couple of formulae for you:
- LEFT(Description, FIND("First Name",Description)-1)
- RIGHT(Description, LEN(Description)-FIND("First Name",Description)+1)
Here is a string of text:
"Location: Boston First Name: Bob Last Name: Jones"
- Formula 1 will output "Location: Boston "
- Formula 2 will output "First Name: Bob Last Name: Jones"
Thus, you can create a workflow with two field updates:
- Set Text__c equal to the value of formula 1
- Set Description equal to the value of formula 2
Tweak as needed, e.g. if you want to remove trailing spaces wrap it in a TRIM function.