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
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,"(")
);
You do not store the result of each iteration where you could see it. How do you know it is not working?
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,"(")
);
Your code partially works, it just lacks the assignment. Try this:
For Each Row(:LOT_NUMBER = Word(1, :LOT_NUMBER, "("));