Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Highlighted
wjalford
Level III

Need to remove part of a string starting with (

I have a string in a cell that has the format AB1234(Name).  I would like to remove everthing past the 4.  The result would be each cell under the column LOT_NUMBER would be AB1234.  I have tried the word function ;  for each row(word(1,:LOT_NUMBER,"("));  This did not work.  Can you please give me a recommendation.

 

Regards,

 

Wayne

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: Need to remove part of a string starting with (

As Mark indicates, you need to replace the value in the column, not just find it

 for each row(
     :LOT_NUMBER = word(1,:LOT_NUMBER,"(")
);
Jim

View solution in original post

3 REPLIES 3
Highlighted

Re: Need to remove part of a string starting with (

You do not store the result of each iteration where you could see it. How do you know it is not working?

Learn it once, use it forever!
Highlighted
txnelson
Super User

Re: Need to remove part of a string starting with (

As Mark indicates, you need to replace the value in the column, not just find it

 for each row(
     :LOT_NUMBER = word(1,:LOT_NUMBER,"(")
);
Jim

View solution in original post

Highlighted
ms
Super User ms
Super User

Re: Need to remove part of a string starting with (

Your code partially works, it just lacks the assignment. Try this:

For Each Row(:LOT_NUMBER = Word(1, :LOT_NUMBER, "("));

 

Article Labels

    There are no labels assigned to this post.