cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
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
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

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?

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
ms
Super User (Alumni) ms
Super User (Alumni)

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, "("));