BookmarkSubscribeRSS Feed
wjalford

Contributor

Joined:

Jan 16, 2019

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

Joined:

Jun 22, 2012

Solution

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
3 REPLIES 3
markbailey

Staff

Joined:

Jun 23, 2011

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!
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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

Joined:

Jun 23, 2011

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