I have been digging into the documentation for a use of Substring that would allow me to define a substring based on a common delimiter in a field.
For instance I have a field in a data extension that is defined as name1_ - this field will always have a first and last name define in it. As a result I do not always have a constant fixed number of characters from which to apply substring as I see it defined in the Syntax Guide.
What I would like to do is this:
Name1_ = Dave Smith
From this field I would like to grab only the last name (Smith) and populate it as a variable for use elsewhere in my email. The one constant I do know of is that every time there will be a first and last name, and that I only want the last name in a variable.
I simply cannot find a sample application of this process in the ET documentation.
Ultimately it would end up like this:
%%[ Set @DIVLead = Substring(name1_ ,0,-1)Output(@DIVLead) ]%%
And @DIVLead would be Smith.