topic Re: Removing the end of a string of variable length in Discussions

Removing the end of a string of variable length

DanAlexander — Fri, 09 Jun 2023 23:40:12 GMT

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

Re: Removing the end of a string of variable length

David_Burnham — Fri, 09 Oct 2020 20:10:28 GMT

Something like Left(:Protocol, Length(:Protocol) - 4)

Re: Removing the end of a string of variable length

JLX — Sat, 10 Oct 2020 03:55:25 GMT

I agree with @David_Burnham , you can get results by directly using left, if you really wanna use word, maybe you can refer to this one below (I also attached data table in attachment):

Names Default To Here( 1 );
Clear Log();
dt = Current Data Table();
new_col = dt << New Column( "Trimmed Protocol",
	character,
	formula( Word( [1 -2], :Protocol, "-" ) )
);

Re: Removing the end of a string of variable length

Mark_Bailey — Sat, 10 Oct 2020 13:18:27 GMT

I thought of using the Left() function, too. Here is my take:

Names Default to Here( 1 );

string = "AAA-BB-1234-19-001";

Left( string, Contains( string, "00") - 2 );

I recommend that you select Help > Scripting Index and select Functions > Character. There is a lot of built-in support for manipulating character strings.

Re: Removing the end of a string of variable length

DanAlexander — Sat, 10 Oct 2020 23:11:37 GMT

Thank you, I tried your solution and it worked perfectly.

Re: Removing the end of a string of variable length

Crew — Thu, 31 Oct 2024 14:04:25 GMT

// I had a similar problem with removing the file name from the file path

Names Default To Here( 1 );

dt = Current Data Table();

current_file = dt << Get Path();

current_directory = Word([1 -2], current_file, "\");

// return the full string ([1 -1]), except for the last word ([1 -2])

data = Pick File(

"Select Data Files",

current_directory,

{"Excel|csv","JMP Files|jmp;jsl;jrn","All Files|*"},

"", multiple

);