问题描述
所以我所拥有的是一个MS Word docx文件,其中包含一些不是很好排序的数据.
So what I have is a MS Word docx file that contains some data which is not really sorted really nice.
/示例输出
1.姓氏,名字
地址,城市,州邮政编码
Address, City, State Zip
通过执行Ctrl + Shift + *,我可以查看文件中存在的所有特殊字符.
By doing Ctrl+Shift+* I can view all the special characters that exists within the file.
(¶,˚等...)
然后将其替换为,"以用作分隔符,然后以excel格式导出文件.
then replace them with a "," to act as a separator then export the file on an excel format.
是否可以使用PHP替换此符号?
Would there be a way to replace this symbols using PHP?
推荐答案
这个问题在这里已经被困扰了很多..之所以做出回应,是因为您的想法有点曲折.
This issue has been flogged many times here .. am only responding because yours have a little twist.
您需要做的是删除所有不需要的字符,然后用,"替换所有空格"
What you need to do is remove all the characters you don't want , then replace all spaces " " with ","
不删除任何ASII字符(3个示例)
Removing none ASII Characters (3 Examples)
$string = preg_replace('/[^(\x20-\x7F)]*/','', $string);
$string = preg_replace('/[\x00-\x1F\x80-\xFF]/', '', $string);
$string = preg_replace( '/[^[:print:]]/', '',$string);
删除UTF8字符
$string = preg_replace('/[\x00-\x08\x0B\x0C\x0E-\x1F\x80-\xFF]/u', '', $string);
删除换行符,回车符和制表符
Removing Line Feeds , Carriage Returns and Tabs
$string = preg_replace('/[\x00-\x1F\x80-\xFF]/u', '', $string);
用,"替换";
$string = str_replace(" ",",",$string);
$string = trim($string,",");
您现在有更多的选择..
You have more than enough options now ..
我希望这对您有帮助
谢谢:)
这篇关于PHP-将MS Word特殊字符(^ l,^ p,^ s)更改为“,".的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!