Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

Avatar

Avatar

florentlb

Total Posts

1.1K

Likes

234

Correct Answer

239

Avatar

florentlb

Total Posts

1.1K

Likes

234

Correct Answer

239
florentlb

10-10-2017

Hey,

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

Florent