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}, ‘M:|-]’, ‘’),

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.

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!