title: Remove the rest of the string right after space
body: <p>I am getting string like this:</p>
  
  <pre><code>foreach (DataRow dt in dt_power_conv.Rows) {
      _powerConv.leit_conv.Add(dt["leit_"].ToString();
  }
  </code></pre>
  
  <p>It's adding "ABB for the first time". I need to get "ABB",the rest should be removed. I have tried the following, but it does not change anything:</p>
  
  <pre><code>foreach (DataRow dt in dt_power_conv.Rows) {
      _powerConv.leit_conv.Add(dt["leit_"].ToString().Substring(0,(dt["leit_"].ToString()).LastIndexOf(" ") + 1));
  }
  </code></pre>