Powerpivot delimited text error

[paivers]

I'm importing a text file with pipe delimited fields as follows. The problem is that it truncates the row after the 3 in 3" x 4". I suspect the double quote (meaning 2 inch symbols) is throwing off the string storage, but it also leaving the 1, and 0.000 as blanks. Is there a workaround for this?

CHARGES|272|88888|9999999|ORSUP-INTERCEED 3" X 4"| 1| 0.000|

- Pete

 

[paivers]

I put in a support ticket with Microsoft for this, and a bug was identified and submitted. A workaround is to use "", but you have to edit your source data.
- Pete