Help

Formula - remove text

Topic Labels: Formulas
Solved
Jump to Solution
2087 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Thomas_D_Hoe
4 - Data Explorer
4 - Data Explorer

Hi, I want to remove the text “project to archive” in my primary field. Can I do this with a formula?
This is a primary field, I don’t know if that’s an issue?
image

1 Solution

Accepted Solutions
Williams_Innova
7 - App Architect
7 - App Architect

Hi @Thomas_D_Hoe,

Welcome to the community!

Yes, you can and there are a few ways to go about this. First, is your primary field already a formula field? If so, do you know where “Project to Archive” is coming from? You may be able to take care of it prior to it coming into this primary field. That said, if you aren’t able to do that, you could use a few different formulas to accomplish this.

Use the Replace formula:

REPLACE(“Project to Archive,”, 1, 19, “”)

Use the Substitute formula:

SUBSTITUTE(“Project to Archive,”, “Project to Archive,”, “”)

You could also use a combination of Find and Right too. Reference how to use those formulas below.

Thanks,
Chris

See Solution in Thread

1 Reply 1
Williams_Innova
7 - App Architect
7 - App Architect

Hi @Thomas_D_Hoe,

Welcome to the community!

Yes, you can and there are a few ways to go about this. First, is your primary field already a formula field? If so, do you know where “Project to Archive” is coming from? You may be able to take care of it prior to it coming into this primary field. That said, if you aren’t able to do that, you could use a few different formulas to accomplish this.

Use the Replace formula:

REPLACE(“Project to Archive,”, 1, 19, “”)

Use the Substitute formula:

SUBSTITUTE(“Project to Archive,”, “Project to Archive,”, “”)

You could also use a combination of Find and Right too. Reference how to use those formulas below.

Thanks,
Chris