PHP - XML到CSV删除XML空白

Question

I'm trying to convert a XML file to CSV using PHP, but I have a problem with whitespaces for some values inside a tag. This is the XML:

<Product>
<Code>1234</Code>
<Name>product name</Name>
<Category>some category</Category>
<Manufacturer>manufacturer</Manufacturer>
<Price>                 100</Price>
<Stock>1</Stock>
</Product>

As you can see, there's a lot of whitespace inside the Price tag, which messes with my CSV formatting. I've tried this but it didn't work:

$Product->Price = preg_replace("/>\s+</", "><", $Product->Price);

Any help will be greatly appreciated. Thanks in advance.

Answer 1

Try trim(). From the php manual:

This function returns a string with whitespace stripped from the beginning and end of str. Without the second parameter, trim() will strip these characters:

" " (ASCII 32 (0x20)), an ordinary space. "\t" (ASCII 9 (0x09)), a tab. " " (ASCII 10 (0x0A)), a new line (line feed). "" (ASCII 13 (0x0D)), a carriage return. "\0" (ASCII 0 (0x00)), the NUL-byte. "\x0B" (ASCII 11 (0x0B)), a vertical tab.