Velocity email script split string | Community
Skip to main content
H
HaroonRa
New Participant
October 15, 2020
Solved

Velocity email script split string

  • October 15, 2020
  • 1 reply
  • 4803 views

Hi,

 

I have the following code which looks up a field in Marketo and pulls through the content, but I have an issue I am trying to start a new row when a certain delimiter "Part" pops up within the content:

 

#if(!$lead.First_5_Lines_in_Basket__c.isEmpty()) #set($First_5_Lines_in_Basket__c = $lead.First_5_Lines_in_Basket__c) #foreach($fivelines in $First_5_Lines_in_Basket__c.split("\n")) $fivelines #end #end

 

The content pulling through is for example - 

Part - 7984219, P2220 Oscilloscope Probe, Passive, 300 V Qty. - 11 Part - 2497216, ATREB215-XPRO - Expansion Board, AT86RF215 2.4GHz/Sub 1GHz Multi-Band Transceiver, IEEE 802.15.4/4g Compliant Qty. - 3

 

But would like it to split to next row when "Part" comes up within the content, so should look like as follows:

 

Part - 7984219, P2220 Oscilloscope Probe, Passive, 300 V Qty. - 11
Part - 2497216, ATREB215-XPRO - Expansion Board, AT86RF215 2.4GHz/Sub 1GHz Multi-Band Transceiver, IEEE 802.15.4/4g Compliant Qty. - 3

 

Any help would be appreciated.

 

Thanks

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

By "split to next row" I assume you mean "Insert an HTML line break"... do try to be as as clear as possible because there's no single definition of of row and line that covers both Text and HTML.

 

If that's indeed what you mean, then find the word "Part" and prepend it with <br>.

#if( !$lead.First_5_Lines_in_Basket__c.isEmpty() ) #set( $First_5_Lines_in_Basket__c = $lead.First_5_Lines_in_Basket__c ) #foreach( $fivelines in $First_5_Lines_in_Basket__c.split("\n") ) ${fivelines.replaceAll("Part","<br>Part")} #end #end

 

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
October 15, 2020

By "split to next row" I assume you mean "Insert an HTML line break"... do try to be as as clear as possible because there's no single definition of of row and line that covers both Text and HTML.

 

If that's indeed what you mean, then find the word "Part" and prepend it with <br>.

#if( !$lead.First_5_Lines_in_Basket__c.isEmpty() ) #set( $First_5_Lines_in_Basket__c = $lead.First_5_Lines_in_Basket__c ) #foreach( $fivelines in $First_5_Lines_in_Basket__c.split("\n") ) ${fivelines.replaceAll("Part","<br>Part")} #end #end

 

H
HaroonRaAuthor
New Participant
October 16, 2020

Thanks Sanford, that has helped.

Terms & ConditionsAccessibility statement

Loading footer...