Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Substring function

jael91407431
Level 3
Level 3

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.

3 Replies
Jean-Serge_Biro
Community Advisor
Community Advisor

Hi Jael,

Please don't duplicate entries, see reply there:

Substring function

Regards
JS

jael91407431
Level 3
Level 3

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
Level 10

Hey,

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

Florent