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
BedrockMission!

Learn More

View all

Sign in to view all badges

Substring function

Avatar

Avatar
Validate 10
Level 3
jael91407431
Level 3

Likes

13 likes

Total Posts

46 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
jael91407431
Level 3

Likes

13 likes

Total Posts

46 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
jael91407431
Level 3

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
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct Reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct Reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Jean-Serge_Biro
MVP

19-09-2017

Hi Jael,

Please don't duplicate entries, see reply there:

Substring function

Regards
JS

Avatar

Avatar
Validate 10
Level 3
jael91407431
Level 3

Likes

13 likes

Total Posts

46 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
jael91407431
Level 3

Likes

13 likes

Total Posts

46 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
jael91407431
Level 3

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
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

10-10-2017

Hey,

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

Florent