« Excel files to be derived from dspace to go into Drupal | Main | Instructions to allow harvesting of log files by URCHIN »

how to get rid of '\n' in an sql call

Select metadata_field_id , metadata_schema_id , element , qualifier , translate(scope_note, '\n',' ' ) From metadatafieldregistry ;

Posted by Jeffrey Silvis on August 5, 2010 10:36 AM |

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)