Substring function

Avatar

Avatar

jael91407431

Avatar

jael91407431

jael91407431

18-09-2017

Can anyone point me in the right direction to create from the advanced SQL list of functions:

listoffunctions.png

...a substring of  Substr(MKTG_PROMO_CELL_KEY) from character 13 to 6 as "source_id" (field)?

So the function formula is "Substring (<String>, <Offset>, <Length>)", how can I select from the above field ("MKTG_PROMO_CELL_KEY") the characters 13 to 6 within that field (to create a new field ,"source_id")?

Thanks.

Finally, can anyone point me to a good online resource that teaches or lists all of these SQL functions. They're are a lot of SQL sites that lists SQL functions, but anyone know a good site that lists all of them found in Adobe Campaign?

Thanks.

View Entire Topic

Avatar

Avatar

jael91407431

Avatar

jael91407431

jael91407431

10-10-2017

Yes, thank you so much and sorry for the dup.

Jae