Help

Formula - remove characters

Topic Labels: Formulas
3770 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Gardner1
7 - App Architect
7 - App Architect

Hello-

I need some help, need to remove the :, |, - characters for when the field type is not selected so it doesnt look lie this:

MARKETNG REQUEST | | GRAPHIC DESIGN: STICKER - 5 X 7 ASTRA NATIONAL TOY STORE MONTH & TRYAZON MAILINGS

or

MARKETNG REQUEST | MON: YELLOWSTONE | DIGITAL MEDIA: SHOWCASE -

4 Replies 4

Hi,

use substitute
or regex_replace(field, “[:|-]”, “”)

Thank you!

It’s still shows unless I am missing something:

MARKETNG REQUEST | OFFICE - WALL DECORATION | - CUSTOM SHADOW BOXES

MARKETNG REQUEST | PHOTOGRAPHY - SHOWCASE | CLUE: FINDING NEMO -

SO when Corporate Task Description is blank or any other field type is blank, the character that separates will be removed.

IF(REGEX_REPLACE({MARKETING CAMPAIGN}, ‘[:|-]’, ‘’),
CONCATENATE(
{MARKETING CAMPAIGN},
IF( {ASSET TYPE}, " | " & {ASSET TYPE}),
IF( {ASSET TASK}, " - " & {ASSET TASK}),
IF( {CAMPAIGN TYPE}, ": " & {CAMPAIGN TYPE}),
IF( {CORPORATE TASK DESCRIPTION}, " - " & {CORPORATE TASK DESCRIPTION})

),
‘MARKETNG REQUEST’
& ’ | ’ &{ASSET TYPE}
& ’ - ’ &{ASSET TASK}
& ’ | ’ &{Item Description}
& ’ - ’ &{CORPORATE TASK DESCRIPTION})

In fact, you missed most important part of info in first message. Now it’s more clear. please disregard part about sub and regex
Your goal is not to remove chars, you need to debug why blank values counted by formula as non-blank. Usually it’s lookups, but not limited to.

Scott_Gardner1
7 - App Architect
7 - App Architect

Where do I insert, if Marketing Campaigns is blank, Then in place of {Marketing Campaigns}, ‘Marketing Request’ is auto filled:

MARKETING CAMPAIGNS - OFFICE: WALL DECORATION (IF FILLED IN)

If not:

MARKETING REQUEST - OFFICE: WALL DECORATION (IF FILLED IN)

IF(
{MARKETING CAMPAIGN},
{MARKETING CAMPAIGN} & IF(
{ASSET TYPE},
" - " & {ASSET TYPE},“-”& {Item Description}
) & IF(
{ASSET TASK},
“: " & {ASSET TASK}
),
IF(
OR(
{ASSET TASK},
{ASSET TYPE},
{Item Description}
),
IF(
{ASSET TYPE},{ASSET TYPE} &
IF(
{ASSET TASK},”: " & {ASSET TASK} &
IF(
{Item Description},": " & {Item Description}
)
)
)
))

Thank you!