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