Substring function | Community
Skip to main content
Level 3
September 19, 2017

Substring function

  • September 19, 2017
  • 1 reply
  • 4121 views

Hi,

I had created this function, Substring([contact_history_vw/@mktg_promo_cell_key], 13, 6), for the following formula: Substr(MKTG_PROMO_CELL_KEY, 13,6).

The expression is expressed in Adobe Campaign as, "sub string of mktg_promo_cell_key for ita_contact_history_vw starting at offst 13 of length 6":

Not having access to the actual data field, "MKTG_PROMO_CELL_KEY,"  assuming that the values are CHAR, what does, "starting at offset 13 of length 6" mean?

Is this correct Substring function for the query formula, "Substr(MKTG_PROMO_CELL_KEY, 13,6)"?

Thank you.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Jean-Serge_Biro
Level 10
September 19, 2017

Hi Jael,

Please don't duplicate entries, see reply there:

Substring function

Regards
JS

Level 3
October 3, 2017

Hi,

Sorry, didn't mean to duplicate thread, I believe I clicked post it twice, not intentionally.

Sorry for the error,

Jae

florentlb
Level 10
October 10, 2017

Hey,

I'm locking this thread since this is a duplicate from Substring function.

Florent