Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Detect line break in while getting the parameter values in APEX
I have a textbox which gets inputs from the user in page1.I am using APEX to create my page 1. On submit the values gets displayed in the page2. The problem is, if the user inputs the data with line breaks in the textbox in page1, the values are getting displayed in the single line in page2. How do i handle it. I am using plsql procedures to display the values in 2nd page via htp.print.
For example: My p1_long_description entered in page 1 as
This is a test script.
It tests for the line break.
Get the values as is.
In page 2 while fetching the values using htp.prn('My long des is :'||:p2_long_description); I am getting it as "This is a test script. It Test for the line break. Get the values as is."
How do i handle this? what should be my approach?
Thanks & Regards,
Best Answer
-
What difficulty are you having implementing it in Apex? It's a straightforward replace. You can do that as part of your query that retrieves the data on the Apex page, or using some Javascript or whatever on the page itself if that's preferable.
Answers
-
If using htp.print, you'll need to replace linebreaks with <br /> (breaking tag).
-
This is PURE HTML and JS code. With the help of below code, you can implement yours.
<html>
<head>
</head>
<script type="text/javascript">
function func(){
var txt;
txt = document.getElementById('text').value;
var text = txt.split(".");
var str = text.join('.</br>');
document.write(str);
}
</script>
<body>
<form >
<label for="text">Description:</label>
<br>
<textarea id="text" name="text" rows="2" cols="50"></textarea>
<br/>
<input type="submit" value="Submit" onclick="func()">
</form>
</body>
-
I need to implement this in APEX. Can anyone please help
-
What difficulty are you having implementing it in Apex? It's a straightforward replace. You can do that as part of your query that retrieves the data on the Apex page, or using some Javascript or whatever on the page itself if that's preferable.
