nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Removing leading zeroes in a character column

lou

Can Regex be used to strip leading zeroes from values in a character column? If so, please provide an example. If not, is there another method?

When leading zeroes occur, the number of leading zeroes can vary. There are values in this column that are non-numeric.

Thanks,

Lou

Accepted answers

vince_faller

This works for me

Names Default To Here( 1 );
dt = New Table( "Example",
	Add Rows( 3 ),
	New Column( "test",
		Character,
		"Nominal",
		Set Values( {"000123", "0AB", "XYZ", "ABC0"} )
	)
);
dt << New Column("No Leading zeroes", character, <<Formula(Regex( :test, "^0*(.*)", "\1" )));

All comments

txnelson

I am not a regex coder, but here is a real simple example of how to do this using other JSL functions:

Names Default To Here( 1 );
dt = New Table( "Example",
	Add Rows( 3 ),
	New Column( "test",
		Character,
		"Nominal",
		Set Values( {"000123", "0AB", "XYZ"} )
	)
);

For each row(
	while(substr(:test,1,1)=="0",
		:test = substr(:test,2)
	)
);

vince_faller

This works for me

Names Default To Here( 1 );
dt = New Table( "Example",
	Add Rows( 3 ),
	New Column( "test",
		Character,
		"Nominal",
		Set Values( {"000123", "0AB", "XYZ", "ABC0"} )
	)
);
dt << New Column("No Leading zeroes", character, <<Formula(Regex( :test, "^0*(.*)", "\1" )));

lou

Thanks! That is what I needed.