将Excel换行符转换为< br> [英] Turn Excel line break into <br>

问题描述

客户向我发送了一个巨大的产品名称和描述清单。说明单元格具有文本换行和许多换行符。我需要将它导入到通过Navicat Premium执行的MySQL。

问题是描述单元格被用作每个产品页面的HTML描述。 p>

有没有办法将Excel的换行符替换为相同的Excel文件中的< br> php函数？

解决方案

一点点的ASCII编码将会有很长的路要走。

设置查找/替换对话框（Ctrl-H）。在查找字段中，按住Alt键，然后从数字键盘中键入010。 （这可以让您找到换行符。）在替换字段中，将您的< br> 。

A client sent me a huge list of product name and descriptions. The Description cells have text wrap and many line breaks. I need to import this into a MySQL which I do through Navicat Premium.

The problem is that the description cell is used as the HTML description of each product page.

Is there a way to replace Excel's line break with the <br> either in the same Excel file or by a php function?

解决方案

A little bit of ASCII coding will go a long way.

Set up the find/replace dialogue (Ctrl-H). In the Find field, hold down the Alt key and type 010 from the numeric key pad. (This lets you find a linefeed character.) In the replace field, put your <br>.

这篇关于将Excel换行符转换为< br>的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！