Here's what I'm running into:
HTML-ENABLED TEXT THAT IS IN A COPY FIELD:<p>A nod to the early era of rock ‘n’ roll, the <strong>G6119TG-62RW-LTD Limited Edition ‘62 Rosewood Tenny with Bigsby® and Gold Hardware </strong>is a solid performer with the standout sound and stunning style that have made Gretsch a household name. Highly resonant with rosewood top, back and sides, the unique voice of this guitar cuts through any mix, standing out from the crowd with That Great Gretsch Sound!™</p>
<p>A pair of rich-sounding TV Jones® TV Classic™ humbucking pickups creates unmistakable vintage snap and guttural growl with lively response, reflecting the natural voice of the guitar. Parallel tone bars connect the top and back of this guitar for authentic vintage tone. Traditional Gretsch controls—individual pickup volume controls, master volume, standby switch and the classic three-position tone switch—allow you to blend and shape the pickups’ sound, creating countless tonal variations. With the new Gretsch “Squeezebox” paper-in-oil capacitors, you get incredibly silky vintage high end. A “rocking” bar bridge with pinned rosewood base reacts in tandem with the Bigsby B6 vibrato tailpiece for stable tuning while the vintage-style bone nut lets the strings slide freely without binding in the slots. The standard “U”-shaped maple neck bears a 12”-radius rosewood fingerboard with 22 vintage small frets for a classic playing experience that works with any style.</p>
<p>An exquisite instrument inspired by one of guitar’s greatest eras, the <strong>G6119TG-62RW-</strong><strong>LTD Limited Edition ‘62 Rosewood Tenny with Bigsby® and Gold Hardware</strong> features the classic aesthetics true Gretsch fans love—gold G-arrow control knobs and Grover® Sta-Tite™ open-back tuning machines, aged white binding with black purfling, aged pearloid Neo-Classic™ thumbnail inlays, rosewood headcap, durable gloss urethane finish and black pickguard with Gretsch logo.</p>
<p> </p>
<ul>
<li>Fully hollow build with rosewood top, back and sides</li>
<li>Rosewood headcap</li>
<li>Set maple neck for effortless access and performance</li>
<li>Aged white body binding with black purfling</li>
<li>Simulated F-holes</li>
<li>12”-radius rosewood fingerboard with 22 vintage small frets and pearloid Neo-Classic™ thumbnail inlays</li>
<li>TV Jones® TV Classic™ humbucking pickups</li>
<li>Master volume, individual pickup volume controls, standby switch and three-position master tone toggle switch</li>
<li>Bigsby® B6G vibrato tailpiece</li>
<li>Rocking bar bridge with pinned rosewood base</li>
<li>Bone nut</li>
<li>Gold hardware</li>
<li>Available in a Natural finish with matching headstock and black pickguard</li>
</ul>
I'M USING THIS VTL:#set($cr="\u000D")
#set($sdn="${SKU_Staging.skuDisplayName}")
#set($sdn=$sdn.replaceAll('\u00ae','').replaceAll('™',''))
##
#set($prpcopy="${SkuList.PRP Copy}")
#set($prpcopy=$prpcopy.replaceAll(' ','').replaceAll('<p> </p>','').replaceAll('<p>','').replaceAll('</p><p>',$cr).replaceAll('</p>','').replaceAll('<br /><br />',"<br />").replaceAll("<br />",$cr).replaceAll("<br>",$cr).replaceAll("</br>",'').replaceAll("<sup>","").replaceAll("</sup>","").replaceAll("</strong>","").replaceAll("<strong>","").replaceAll("</em>","").replaceAll("<em>","").replaceAll("<ul>","").replaceAll("</ul>","").replaceAll("<li>","• ").replaceAll('•',"• ").replaceAll('″','"').replaceAll('´',"'").replaceAll('“','"').replaceAll('‘',"'").replaceAll('”','"').replaceAll('’',"'").replaceAll('™','').replaceAll('—','-').replaceAll('®',"").replaceAll("</li>","").replaceAll('&',"&").replaceAll('–'," - ").replaceAll(' ','').replaceAll('<p></p>','').replaceAll("</li>",'').replaceAll("™",'').replaceAll('\u00ae','').trim())
#set($tax="${SKU_Staging.Taxonomy.code}")
#set($brand="${SkuList.Brand}")
$sdn
$cr$prpcopy.trim()
NOTE: This command doesn't work: .replaceAll(' ',''). This does: .replaceAll('<p> </p>','')This may be because I'm on 8.2?
THIS IS WHAT OUTPUTS:G6119TG-62RW-LTD Limited Edition '62 Rosewood Tenny with Bigsby and Gold Hardware, Rosewood Fingerboard, Natural
A nod to the early era of rock 'n' roll, the G6119TG-62RW-LTD Limited Edition '62 Rosewood Tenny with Bigsby and Gold Hardware is a solid performer with the standout sound and stunning style that have made Gretsch a household name. Highly resonant with rosewood top, back and sides, the unique voice of this guitar cuts through any mix, standing out from the crowd with That Great Gretsch Sound!
A pair of rich-sounding TV Jones TV Classic humbucking pickups creates unmistakable vintage snap and guttural growl with lively response, reflecting the natural voice of the guitar. Parallel tone bars connect the top and back of this guitar for authentic vintage tone. Traditional Gretsch controls-individual pickup volume controls, master volume, standby switch and the classic three-position tone switch-allow you to blend and shape the pickups' sound, creating countless tonal variations. With the new Gretsch "Squeezebox" paper-in-oil capacitors, you get incredibly silky vintage high end. A "rocking" bar bridge with pinned rosewood base reacts in tandem with the Bigsby B6 vibrato tailpiece for stable tuning while the vintage-style bone nut lets the strings slide freely without binding in the slots. The standard "U"-shaped maple neck bears a 12"-radius rosewood fingerboard with 22 vintage small frets for a classic playing experience that works with any style.
An exquisite instrument inspired by one of guitar's greatest eras, the G6119TG-62RW-LTD Limited Edition '62 Rosewood Tenny with Bigsby and Gold Hardware features the classic aesthetics true Gretsch fans love-gold G-arrow control knobs and Grover Sta-Tite open-back tuning machines, aged white binding with black purfling, aged pearloid Neo-Classic thumbnail inlays, rosewood headcap, durable gloss urethane finish and black pickguard with Gretsch logo.
• Fully hollow build with rosewood top, back and sides
• Rosewood headcap
• Set maple neck for effortless access and performance
• Aged white body binding with black purfling
• Simulated F-holes
• 12"-radius rosewood fingerboard with 22 vintage small frets and pearloid Neo-Classic thumbnail inlays
• TV Jones TV Classic humbucking pickups
• Master volume, individual pickup volume controls, standby switch and three-position master tone toggle switch
• Bigsby B6G vibrato tailpiece
• Rocking bar bridge with pinned rosewood base
• Bone nut
• Gold hardware
• Available in a Natural finish with matching headstock and black pickguard
Notice the five lines in the output in between the paragraphs and the unordered list; as well as the lines in between each <LI> in the list.
How can I get rid of those?
Thanks!------------------------------
Jonathan Varo | PIM Lead
Fender Musical Instruments | 480-845-5823
------------------------------
Original Message:
Sent: 04-01-2021 16:01
From: Jonathan Varo
Subject: Help Needed To Remove Spaces Surrounded By Paragraph Tags from HTML Enhanced Field In PIM
I was able to get that to replace but I needed to use this:
replaceAll('<p> </p>','')
Very weird. And it leaves a carriage return in it's place. As a matter of fact, if I replace <ul>, <li>, and others, it leaves a carriage return too. Any way to have a null be a null using replaceAll?
------------------------------
Jonathan Varo | PIM Lead
Fender Musical Instruments | 480-845-5823
Original Message:
Sent: 01-16-2021 01:51
From: Brian Zupke
Subject: Help Needed To Remove Spaces Surrounded By Paragraph Tags from HTML Enhanced Field In PIM
Jon,
You may be able to use the StringUtils class to perform stringSubstitution calls. If you Google search on Apache Velocity 1.7 (the version being used by EnterWorks 8.2) and StringUtils, you should find the details on the methods that can be called. This class would be invoked in the same way the MathTool class is invoked.
-Brian
------------------------------
Brian Zupke | Senior Technical Support Engineer
Winshuttle North America | 9099009179
Original Message:
Sent: 12-19-2020 12:05
From: Jonathan Varo
Subject: Help Needed To Remove Spaces Surrounded By Paragraph Tags from HTML Enhanced Field In PIM
We're planning on upgrading this year, Brian. We may need to wait until we get the new framework in place before fixing this issue.
------------------------------
Jonathan Varo | PIM Lead
Fender Musical Instruments | 480-845-5823
Original Message:
Sent: 12-06-2020 23:51
From: Brian Zupke
Subject: Help Needed To Remove Spaces Surrounded By Paragraph Tags from HTML Enhanced Field In PIM
Jonathan,
One option that becomes available if using the latest Services Framework (which requires EnterWorks 10.x) would be to define a Change Notification that uses a SQL-based REPLACE() function to remove the extraneous paragraphs.
-Brian
------------------------------
Brian Zupke | Senior Technical Support Engineer
Winshuttle North America | 9099009179
Original Message:
Sent: 07-31-2020 18:08
From: Jonathan Varo
Subject: Help Needed To Remove Spaces Surrounded By Paragraph Tags from HTML Enhanced Field In PIM
Hi All.
I have been struggling with this for some time now. Every once in a while, a user will paste an empty paragraph with a space in between. This shows up in the HTML as:
<p> </p>
Creating a replaceAll command with REGEX has been challenging and I've not been successful in having the VTL recognize and remove this code. I would like to use a rule to remove this.
Any ideas?
Thanks in advance.
------------------------------
Jonathan Varo | PIM Lead
Fender Musical Instruments | \+1 480 596 9690
------------------------------