Substring function

Avatar

Avatar

jael91407431

Avatar

jael91407431

jael91407431

19-09-2017

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":

1301958_pastedImage_5.png

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.

Replies

Avatar

Avatar

Jean-Serge_Biro

MVP

Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
MVP

19-09-2017

Hi Jael,

Please don't duplicate entries, see reply there:

Substring function

Regards
JS

Avatar

Avatar

jael91407431

Avatar

jael91407431

jael91407431

02-10-2017

Hi,

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

Sorry for the error,

Jae

Avatar

Avatar

florentlb

Avatar

florentlb

florentlb

10-10-2017

Hey,

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

Florent