topic Need to remove part of a string starting with ( in Discussions

Need to remove part of a string starting with (

wjalford — Mon, 11 Feb 2019 13:23:01 GMT

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

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

Mark_Bailey — Mon, 11 Feb 2019 13:29:40 GMT

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

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

txnelson — Mon, 11 Feb 2019 13:37:36 GMT

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

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

ms — Mon, 11 Feb 2019 13:39:18 GMT

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

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