Vintage Erotica Forums - View Single Post - Scandi Delights

**effCup** · January 28th, 2018, 03:23 AM

Re. the loss of leading zeros (due to Excel):

I've been re-looking at the raw data & have improved my regular expressions so that it'd be a bit less manual work to re-do the data into columns (mostly), but the thing is that I think the only way to prevent Excel stripping the leading zeros is to put a ' before them, and unlike where one does that manually within Excel, if I do that to the text file prior to importing into/opening with Excel (that's the only reasonable/manageable way, given the quantity), then they remain visible within excel. That is: Excel then doesn't treat them as "special" characters.

So: that way keeps the leading zeros but also prepends a '. So I still wonder whether it's really worth all the effort of re-doing the data?

January 28th, 2018, 03:23 AM	#10
effCup *Vintage Idiot* Join Date: Feb 2012 Location: History Posts: 22,136 Thanks: 226,729 Thanked 356,769 Times in 21,631 Posts	Re. the loss of leading zeros (due to Excel): I've been re-looking at the raw data & have improved my regular expressions so that it'd be a bit less manual work to re-do the data into columns (mostly), but the thing is that I think the only way to prevent Excel stripping the leading zeros is to put a ' before them, and unlike where one does that manually within Excel, if I do that to the text file prior to importing into/opening with Excel (that's the only reasonable/manageable way, given the quantity), then they remain visible within excel. That is: Excel then doesn't treat them as "special" characters. So: that way keeps the leading zeros but also prepends a '. So I still wonder whether it's really worth all the effort of re-doing the data?