0

I'm trying to export XML from Excel. Some of my cells have tabs in them if the form of 	 but when they export to XML they become 	. I am able to fix this in SublimeText with a simple find/replace but it would be nice to just have it come out right. Is there a way to correct this?

kjhughes
  • 106,133
  • 27
  • 181
  • 240
jseymour186
  • 31
  • 3

1 Answers1

0

	 is how a tab is written in XML. If it would be a real tab, it would be whitespace and ignored.

So the extract is correct, and your 'correction' would break it.

Aganju
  • 6,295
  • 1
  • 12
  • 23
  • Im sorry im not sure what happened to my question. the stuff in quotes isn't right. what is happening is that where " " occurs in the spreadsheet "	" is generated on export. Sorry for the mixup. not sure why that happened. – jseymour186 Jun 16 '16 at 15:14
  • I see. My display adds another level of confusion... I understand your problem now. – Aganju Jun 16 '16 at 15:19