Hope someone can help.
I did an export of our users from Active Directory using CSVDE.exe. This generated a csv file which I then work with in Excel and word.
My problem is that any field that has either a carrige return, or an accent in the name come out as a long HEX string with an x' at the start and an ' at the end instead of the proper word.
For example Stephane (The e should have an accent, but I can't display that here) comes out as X'5374c3a97068616e65'.
What I need help with is a formula/macro/vba code, that would search for all cells whos data starts with x'. Once found I need to remove the x' from the begining and the ' from the end. Then pair each 2 characters of hex together and convert then to ascii. If we take the example above, X'5374c3a97068616e65' would become 5374c3a97068616e65, then 53 becomes S, 74 becomes t, c3 and a9 form e with an accent, 70 is p... and so on and so forth. Then once that's all done, put the converted name/title back into the orginal field.
I thank everyone in advance for any help they can give me with this.
If you need more information, examples, or know of a better way for me to do this, please feel free to let me know.
Thanks
James
I did an export of our users from Active Directory using CSVDE.exe. This generated a csv file which I then work with in Excel and word.
My problem is that any field that has either a carrige return, or an accent in the name come out as a long HEX string with an x' at the start and an ' at the end instead of the proper word.
For example Stephane (The e should have an accent, but I can't display that here) comes out as X'5374c3a97068616e65'.
What I need help with is a formula/macro/vba code, that would search for all cells whos data starts with x'. Once found I need to remove the x' from the begining and the ' from the end. Then pair each 2 characters of hex together and convert then to ascii. If we take the example above, X'5374c3a97068616e65' would become 5374c3a97068616e65, then 53 becomes S, 74 becomes t, c3 and a9 form e with an accent, 70 is p... and so on and so forth. Then once that's all done, put the converted name/title back into the orginal field.
I thank everyone in advance for any help they can give me with this.
If you need more information, examples, or know of a better way for me to do this, please feel free to let me know.
Thanks
James