Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

The text in the XML is coming from the Media Object in JDE. We have the Media Object broken down in to bracketed sections and JDE pulls 1 of the bracketed sections to show up on the XML. So I don't have the ability to break apart and bring each line in as separate field. My goal is to make neutral all the text that is…

in How do I write Syntax to remove blank lines? Comment by TRACY HENGST Mar 2, 2017 8:00AM
I just updated my original posting (the formatting showed up strange on it). This however is what I'd like it to look like. Basically just removing any double carriage returns. Ready Date - Nov 23, 2016. Consign to: Company XYZ 123 Main Dr E Industrial City, AZ 12345 Ph: 555-123-1234 Attn: Guy Smith Freight Charges prepaid…

in How do I write Syntax to remove blank lines? Comment by TRACY HENGST Mar 1, 2017 8:00AM
I attached to original post. Thanks!

in How do I write Syntax to remove blank lines? Comment by TRACY HENGST Mar 1, 2017 8:00AM