List of Contributions

Bill Allen

This individual is no longer active. Application functionality related to this individual is limited.

Contact Details

My Content

1 to 3 of 3 total

RE: Solving an annoying problem of missing leading zeros

Posted By Bill Allen 07-24-2019 09:31
Found In Egroup: Data Points \ view thread
Oh right. I think the zeroes save fine to the CSV file - it's when you try to open the CSV in Excel again - Excel will then convert it back. If you open the saved CSV in notepad you'll see the zeroes. It should also import to your other systems fine! P.s. if you need to avoid the issue of opening ...

RE: Solving an annoying problem of missing leading zeros

Posted By Bill Allen 07-24-2019 04:21
Found In Egroup: Data Points \ view thread
You can use the TEXT function: =TEXT(A1,"00000000000000000000") ------------------------------ William Allen Data Engineer Pitney Bowes Software Ltd Henley-On-Thames ------------------------------

RE: Whats your favorite data attribute?

Posted By Bill Allen 06-14-2019 04:46
Found In Egroup: Data Points \ view thread
Hi Keith - I agree with Dan (although my opinion is biased!). Standardizing the Brandname is quite a complex task due to the many naming variations and brand relationships/subsidiaries that exist (such as Hilton - DoubleTree etc.). We have recently upgraded our processing to use Natural Language Processing ...