---
title: "Remove all after certain character"  
description: "Remove all after certain character"  
author: "Anonymous User"  
published: 2013-02-14  
updated: 2013-02-16  
canonical: https://www.mindstick.com/forum/603/remove-all-after-certain-character  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# Remove all after certain character

Hi Everyone!

I have got a [C# project](https://www.mindstick.com/forum/159167/how-can-i-create-test-environment-for-my-c-sharp-project) and some [data](https://www.mindstick.com/articles/13050/salesforce-aiming-to-dominate-predictive-analytics-with-data-science) like:

Thinness (n.)\
Slenderness (n.)\
A fat lot\
Hefty (a.)\
Tucking of loincloth\
I want these data just like that below

Thinness \
Slenderness \
A fat lot\
Hefty \
Tucking of loincloth\
I tried

[UPDATE](https://www.mindstick.com/forum/156353/what-is-hummingbird-update) dic\
SET english = [LEFT](https://www.mindstick.com/articles/12768/don-t-be-left-behind-with-the-new-it-revolution)(english, CHARINDEX('(', english) - 1)\
WHERE (CHARINDEX('(', english) > 0)\
But I get [error](https://yourviews.mindstick.com/view/88527/fixing-quickbooks-error-4120-reinstalling-vs-repairing):

[Token](https://www.mindstick.com/forum/159447/manage-token-expired-in-mern-auth) in error LEFT

How can I [handle](https://www.mindstick.com/articles/311004/suede-skillet-handle-cover) that?

Thanks in [advance](https://www.mindstick.com/blog/33258/jee-mains-and-jee-advance-exams)

## Replies

### Reply by AVADHESH PATEL

Hi Jeet!

In place of LEFT used SUBSTRING as below

UPDATE dic\
SET english = SUBSTRING(english, 1, CHARINDEX('(', english) - 1)\
WHERE (CHARINDEX('(', english) > 0)


---

Original Source: https://www.mindstick.com/forum/603/remove-all-after-certain-character

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.