topic Re: Removing Part of a string of variable length in Discussions

Removing Part of a string of variable length

dn610 — Mon, 24 Mar 2025 15:55:20 GMT

Hi - I'm trying to remove the IDs from the Name column (e.g. C17-2612.4 2612.4, C23, etc.). Can someone help me with the jsl?

txnelson — Mon, 24 Mar 2025 16:13:24 GMT

Here is one approach

Names Default To Here( 1 );
For Each Row(
	name = Substr(
		name,
		Length( Word( 1, name, "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) ) + 2
	)
);

jthi — Mon, 24 Mar 2025 16:20:46 GMT

Regex like this might work

Regex(:Name, "C.* ([A-Z].*)", "\1")

dn610 — Mon, 24 Mar 2025 16:32:06 GMT

Thank you both! Regex didn't work, but Jim's solution did work.