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

Avatar

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

Avatar

Level 3

Hi,

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

Sorry for the error,

Jae