?
Solved

trim ( off string

Posted on 2007-03-19
4
Medium Priority
?
855 Views
Last Modified: 2008-01-09
Hello Experts,
Can you help me with string manipulation?
I would like to take this string:
English Language(2)
and take of the everything to the right of the parenthesis so the string looks like this:
English Language
I have made a few attemps with no luck.
Any help you can provide would be appreciated.
0
Comment
Question by:shogun5
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 200 total points
ID: 18753603
Try this

Create a frmula
Name - RemoveParen
Formula
Local NumberVar ParenLoc;
ParenLoc := InStr({YourString}, "(");
Left({YourString},ParenLoc-1)

mlmcc
0
 

Author Comment

by:shogun5
ID: 18753645
Yep...that was it!  
Thank you.
Can you explain what is happening with this code:

  Left({YourString},ParenLoc-1)

Thank you.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 18753815
Left(String,Length)

It takes the first length characters of the string.
ParenLoc has the position of the ( so you want the characters upto but not including that one thus the need to subtract 1

mlmcc
0
 

Author Comment

by:shogun5
ID: 18754042
Thank you.
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question