Raw CDR Script

[zameerjafri]

Dear All,
I am using CM 8 and capturing raw calls data on a separate desktop PC. Management wants me to create a script which imports raw CDR data into Excel sheet in organized column. Can someone help and share the script. I am posting three sample rows of CDR file as a reference


091624 213746 00424 07630817822 6508 E 07630817822 7 066661013811026500008 2 403




091624 214113 00057 0619949380 01212100 H 0619949380 7 077771011101026500073 2 402




091624 213032 01139 099145877654 1100 #8 370 051 9 099145877654 014 88881010401020004150 1 300

 

[john3voltas]

I can't see what's stopping you.
You clearly have a file.
Such file has CR/LF (win). Or at least simply LF (lnx).
You just import to excel and tell it the separating character is the space.
If excel can't use the space for that, then just run the file through a find/replace process and find all spaces and replace them with comas or tabs.
And then run the file through excel again and set the separation character either to coma or to tab. There. What else are you looking for?

 

[zameerjafri]

I tried many times using the procedure within excel but fail to do so, in addition the script will automate the procedure rather doing manually in excel every time.