Hello all,
I have a column :Protocol which contains strings of variable length in the format Character, Nominal. I've added some examples below. I am trying to remove the last 4 characters of the string from the column, and keep everything else. The last 4 characters are always one of: -001, -002, -003, or -004. I have tried to accomplish this using Word(), and Substr() but am unable to get it to work:
Protocol
AAA-BB-1234-19-001
AAAA-B-18-002
AA-BBB-123-18-003
AA-B-CC-1001-19-002
This is what I want the column to look like for those 4 rows:
Protocol
AAA-BB-1234-19
AAAA-B-18
AA-BBB-123-18
AA-B-CC-1001-19
I have tried to accomplish this using the Word() functions as follows:
For Each Row(
:Protocol = Word(1, :Protocol, "00")
);