我正在尝试将一些基本的,格式化的纯文本格式转换为PHP数组,以便随后可以进一步处理和显示数据。
以下是我正在使用的匿名数据集...
| |Customer |From |To |Bkg |Cabin |Class |Seat |Accept |
|1 |Palmer Lee Mr |JFK |LAX | |P |P |3K | |
|2 |Palmer Jamiee J Mrs |JFK |LAX |Y |P |P |3F |Boarded |
|3 |Coleman David Mr |JFK |LAX | |P |A |2F |Boarded |
|4 |Coleman Roberta Mrs |JFK |LAX |Y |P |A |2K | |
|5 |Williams Marina Lady |JFK |LAX | |P |F |1K | |
|6 |Graham Christine A Mrs |JFK |LAX | |P |P |4F | |
|7 |Graham Dean A Mr |JFK |LAX | |P |A |4A | |
|8 |Howell Fiona Ms |JFK |LAX | |P |A |5K | |
|9 |Cobb Hamish Mr |JFK |LAX | |P |A |1A | |
|10 |Brown Derek Mr |JFK |LAX | |P |P |2A |Accepted |
|11 |Brown Elizabeth Mrs |JFK |LAX | |P |P |3A |Accepted |
|12 |Reyes Ciaran Mrs |JFK |LAX | |P |F |5A |Standby |
|13 |Reyes Joseph Mr |JFK |LAX | |P |F |5F |Standby |
我尝试使用substr();
,preg_replace();
但没有运气。
有人在这样的数据处理方面有经验吗?希望得到一些帮助!
<?php
$text = "| |Customer |From |To |Bkg |Cabin |Class |Seat |Accept |
|1 |Palmer Lee Mr |JFK |LAX | |P |P |3K | |
|2 |Palmer Jamiee J Mrs |JFK |LAX |Y |P |P |3F |Boarded |
|3 |Coleman David Mr |JFK |LAX | |P |A |2F |Boarded |
|4 |Coleman Roberta Mrs |JFK |LAX |Y |P |A |2K | |
|5 |Williams Marina Lady |JFK |LAX | |P |F |1K | |
|6 |Graham Christine A Mrs |JFK |LAX | |P |P |4F | |
|7 |Graham Dean A Mr |JFK |LAX | |P |A |4A | |
|8 |Howell Fiona Ms |JFK |LAX | |P |A |5K | |
|9 |Cobb Hamish Mr |JFK |LAX | |P |A |1A | |
|10 |Brown Derek Mr |JFK |LAX | |P |P |2A |Accepted |
|11 |Brown Elizabeth Mrs |JFK |LAX | |P |P |3A |Accepted |
|12 |Reyes Ciaran Mrs |JFK |LAX | |P |F |5A |Standby |
|13 |Reyes Joseph Mr |JFK |LAX | |P |F |5F |Standby |";
//gets each line in a array
$pieces1 = explode("\n", $text);
// now create a loop if u want with array length and get each line and explode it again
// OR just callto any line by $pieces1[number]
$pieces2 = explode("|", $pieces1[3]);
// Remove first and last blank elements
$result = array_slice($pieces2, 1, -1);
?>
// print_r($result)
Array
(
[0] => 3
[1] => Coleman David Mr
[2] => JFK
[3] => LAX
[4] =>
[5] => P
[6] => A
[7] => 2F
[8] => Boarded
)
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句