Body: <p>I'm using CiviCRM 5.62.1, CiviRules 2.49, Drupal 7.98</p>
  <p>I have created a View which creates a table with organisation name and contact sub type, grouped by region. However, on the display, the contact sub types come up with underscores instead of spaces eg. Arts_Stream_of_Sanctuary (see pic below). Is there any way of getting the display to put a space instead of an underscore?</p>
  <p>I figured out that I can create a conditional that works with one phrase ie. change 'Arts_Stream_of_Sanctuary' to 'Arts Stream of Sanctuary' but I want to do that for all the variations without creating a new conditional / column for each</p>
  <p><a href="https://i.sstatic.net/LFxZ0tdr.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/LFxZ0tdr.jpg" alt="enter image description here" /></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-07-01T12:50:55.297Z
Comments.Text: Have you used drupal views or Civi search kit?
Comments.UserDisplayName: Pradeep Nayak
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-07-01T13:04:31.310Z
Comments.Text: I have used Drupal Views
Comments.UserDisplayName: Joanna S
Tags: <drupal-views>
Title: How do I display contact sub types in a View without the underscores?
ThreadText: # How do I display contact sub types in a View without the underscores?
  
  (Asked by: username_0 on 2024-07-01)
  
  I'm using CiviCRM 5.62.1, CiviRules 2.49, Drupal 7.98
  
  I have created a View which creates a table with organisation name and contact sub type, grouped by region. However, on the display, the contact sub types come up with underscores instead of spaces eg. Arts\_Stream\_of\_Sanctuary (see pic below). Is there any way of getting the display to put a space instead of an underscore?
  
  I figured out that I can create a conditional that works with one phrase ie. change 'Arts\_Stream\_of\_Sanctuary' to 'Arts Stream of Sanctuary' but I want to do that for all the variations without creating a new conditional / column for each
  
  [![enter image description here](https://i.sstatic.net/LFxZ0tdr.jpg)](https://i.sstatic.net/LFxZ0tdr.jpg)
  
  **Tags:** drupal-views
  
  > **Comments:**
  > **username_1**: Have you used drupal views or Civi search kit?  
  > **username_0**: I have used Drupal Views  
  
  ---
  
  ## 0 answers
  
  