Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

making a new line in a data table
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: making a new line in a data table
#22284
making a new line in a data table 12 Years, 12 Months ago Karma: 0
Hello everyone,

On the frontend my text string in a colunm (Farmers information) comes up like this:

Farm Abbewood Acres Farm Nita Gilmer 508 Stevenson Road Abbeville SC 29620 N/A 864-992-7923


Is there a way to edit the text string in excell or some other program so that the CSV file will output a string that has "new lines"?

Farm
Abbewood Acres Farm
Nita Gilmer
508 Stevenson Road Abbeville SC 29620
N/A
864-992-7923
The administrator has disabled public write access.
 
#22311
Re:making a new line in a data table 12 Years, 12 Months ago Karma: 760
Hello,

It is possible to use "<BR />" HTML tag to add new line. CSV file will look like:

Code:


"Col1","Col2"
"Line1<br/>Line2","Value"



Regards,
ARI Soft
The administrator has disabled public write access.
 
#22797
Re:making a new line in a data table 12 Years, 11 Months ago Karma: 0
When I add <br /> in an Excel document and go to save it as a .csv, it will not save because Excel will not let you save with the <br /> in a column. Is there any other way that the table will read break returns?
The administrator has disabled public write access.
 
#22804
Re:making a new line in a data table 12 Years, 11 Months ago Karma: 760
We can save <br/> tag in CSV file with help MS Excel without problem. If you have any difficulties with it, you can use OpenOffice application.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#22806
Re:making a new line in a data table 12 Years, 11 Months ago Karma: 0
This is the message Excel gives me when I try to save the CSV with the <br />:

This workbook contains features that will not work or may be removed if you save it in the selected file format. Do you want to continue?

To save the workbook in this format, which may disable or remove some features, click Continue. To preserve the workbook, click Cancel, and then save the workbook in a different file format.


However, I discovered that the csv file does indeed save with the <br /> tags, but I am unable to upload it into Joomla because I get an error that states: Possible IE XSS Attack found. And the file doesn't upload at all.

Is there another way to make break returns in the columns without using <br />?
Last Edit: 2011/12/15 08:13 By corkcork.
The administrator has disabled public write access.
 
#22808
Re:making a new line in a data table 12 Years, 11 Months ago Karma: 760
Use a file manager extension to upload files. For example eXtplorer.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 12