I needed to clean up the output from a csvde query by removing the DN from the results. The DN was in the format "CN=...,OU=...,DC=...,DC=...",other data.
To remove only the DN from each line and leave the other data, I pasted the results into Microsoft Word 2007, then opened the 'Replace' dialog. I then clicked on the 'More' button at the bottom left which revealed additional options, including one called 'Use Wildcards'. I put a check against this option, then did a search for "*", to replace with nothing. This immediately cleared up all of my query results, leaving only the other data which I needed.
More information on using wildcards in the Word Find and Replace here: http://www.gmayor.com/replace_using_wildcards.htm
Wednesday 22 December 2010
Wednesday 13 October 2010
Searching for and replacing carriage returns (paragraph breaks) with line breaks in Microsoft Word
A useful tip I picked up today - you can search for carriage returns (paragraph breaks) and line breaks in Microsoft word by using the carat character (^) followed by 'p' or 'l' for paragraph or line as required.
e.g.
^p
^l
On several occasions I've pasted text into Word and hidden carriage returns in the text cause Word to display more spacing between the lines than a normal line break. Doing a simple find and replace using the above characters saves a lot of manual corrections!
e.g.
^p
^l
On several occasions I've pasted text into Word and hidden carriage returns in the text cause Word to display more spacing between the lines than a normal line break. Doing a simple find and replace using the above characters saves a lot of manual corrections!
Thursday 2 September 2010
Fixing the trigger sensitivity of a CME GPP-3 USB MIDI Pedal
A few years ago I purchased a CME GPP-3 USB Grand Piano Style MIDI Pedal to use with my Fatar Studio 900 MIDI keyboard controller. I believe it was (and still is) fairly unique in being modelled very closely on real piano pedals in both look and feel, and is a really useful addition to any studio set-up. I've used mine extensively since I bought it, both live and during recording, and I'd recommend it to anyone used to playing a real piano. I think the Chinese manufacturer (CME) has discontinued it, but you can still find it on eBay!
When I first got it however, I discovered an issue with the trigger sensitivity of the 1st (sustain) pedal. As the screenshot below (taken from Cockos Reaper) shows, the pedal trigger sends a MIDI CC67 value from 0 to 127 as it is pressed down, (CC67=127 when the pedal is fully depressed). The problem was that when the pedal was fully released, the CC67 value was ALSO 127! On further investigation, I found that when fully released, the pedal was not even touching the trigger sensor inside the unit, and as it began to be pressed down it would then touch the sensor and generate CC67 values from 0 to 127, until the pedal was fully depressed. In practical terms, this meant that any MIDI device I was controlling with the pedals would think the sustain pedal was fully depressed when it actually WAS fully depressed, but ALSO when it was fully released. When I wanted the pedal to be 'released' I had to keep the pedal pressed slightly down (i.e. NOT fully released) to ensure that the trigger sensor was being touched and therefore to generate a very low CC67 value, representing a released sustain pedal. The irony was that if I did physically fully release the pedal, it would then send a CC67 value of 127, telling any attached MIDI devices that the pedal was in fact fully depressed again, the complete opposite of what it actually was!
This may have been a problem only on my particular unit, but in case any fellow GPP-3 owners are experiencing the same issue, I've posted some photos and an explanation of my quick and simple D.I.Y. solution below:
1. Flip the unit over and remove the 8 screws from the wooden base (you'll need a Phillips cross-head screwdriver):
2. Remove the wooden base. The pedals are attached to a metal casing inside the frame. You'll need to remove some more screws then the whole pedal unit should come free:
3. Flip over the detached metal casing and find the problem pedal. There should be a metal bracket (as shown below) which presses down onto the trigger sensor on the PCB underneath. Unscrew the bracket:
4. Using some superglue, stick a British penny coin (or your local currency equivalent) on the underside of the metal bracket, and allow a few minutes for it to dry:
5. Reattach the metal bracket to the pedal you removed it from. The added depth of the penny coin should be enough to press lightly on the trigger sensor and prevent it from being fully released when the pedal is not being pressed:
.JPG)
6. Reattach the metal frame to the wooden casing, and then screw the base back on. Test your unit, and you should find it works as intended!
Link to the GPP-3 on the manufacturer's website:
http://www.cme-pro.com/en/product-detail.php?product_id=34
When I first got it however, I discovered an issue with the trigger sensitivity of the 1st (sustain) pedal. As the screenshot below (taken from Cockos Reaper) shows, the pedal trigger sends a MIDI CC67 value from 0 to 127 as it is pressed down, (CC67=127 when the pedal is fully depressed). The problem was that when the pedal was fully released, the CC67 value was ALSO 127! On further investigation, I found that when fully released, the pedal was not even touching the trigger sensor inside the unit, and as it began to be pressed down it would then touch the sensor and generate CC67 values from 0 to 127, until the pedal was fully depressed. In practical terms, this meant that any MIDI device I was controlling with the pedals would think the sustain pedal was fully depressed when it actually WAS fully depressed, but ALSO when it was fully released. When I wanted the pedal to be 'released' I had to keep the pedal pressed slightly down (i.e. NOT fully released) to ensure that the trigger sensor was being touched and therefore to generate a very low CC67 value, representing a released sustain pedal. The irony was that if I did physically fully release the pedal, it would then send a CC67 value of 127, telling any attached MIDI devices that the pedal was in fact fully depressed again, the complete opposite of what it actually was!
This may have been a problem only on my particular unit, but in case any fellow GPP-3 owners are experiencing the same issue, I've posted some photos and an explanation of my quick and simple D.I.Y. solution below:
1. Flip the unit over and remove the 8 screws from the wooden base (you'll need a Phillips cross-head screwdriver):
2. Remove the wooden base. The pedals are attached to a metal casing inside the frame. You'll need to remove some more screws then the whole pedal unit should come free:
3. Flip over the detached metal casing and find the problem pedal. There should be a metal bracket (as shown below) which presses down onto the trigger sensor on the PCB underneath. Unscrew the bracket:
4. Using some superglue, stick a British penny coin (or your local currency equivalent) on the underside of the metal bracket, and allow a few minutes for it to dry:
5. Reattach the metal bracket to the pedal you removed it from. The added depth of the penny coin should be enough to press lightly on the trigger sensor and prevent it from being fully released when the pedal is not being pressed:
6. Reattach the metal frame to the wooden casing, and then screw the base back on. Test your unit, and you should find it works as intended!
Link to the GPP-3 on the manufacturer's website:
http://www.cme-pro.com/en/product-detail.php?product_id=34
Subscribe to:
Posts (Atom)