Hello Dear DaniWeb community
Here I am again, with a new problem :-)
For those of you that are reading every post you probably have already seen that I'm trying to implement an auto-extracting process which extract data from ActiveDirectory, process it in order to make a filtered csv file with specific datas (these data are published in an intranet phonebook). User's data are processed in the filter, and converted into Excel file so that a manager can modify manually the data. And then they are re-imported into the AD in order to maintain updated data in it.
Well my problem is that because of special characters in user's info in ActiveDirectory, I have to use operator "-u" in csvde. And even with that I encounter hex values instead of string.
I think that these hex values are generated every time there is a \n -newline- in the string.
Here is an example:
"CN=BERRY Richard,OU=TestFinance,OU=HR,OU=CORP,OU=CR,DC=mycorp,DC=com","BERRY Richard",BERRY,FR,"Puylouvier",FRANCE,,56000,"+33 1 23 45 67 89","+ 33 1 23 45 67 80",Richard,FRANCE,IT,X'332c206176656e7565204e6577746f6e0d0a',Bob.Malone,Richard.BERRY@mycorp.net," -",
For the field "streetAddress" we have the value "X'332c206176656e7565204e6577746f6e0d0a'", which is a string encoded in hex, and means "3, avenue Newton
" once decoded. As you can see there's a newline just after "Newton".
When I try to filter the csv file I try to search values starting with "X'" and then convert the rest of the value from hex to string, but I have some trouble...
Any idea ?
PS: sorry for the very long explanation !