Removing Part of a string of variable length

[#1]

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?

[#2 · Accepted solution]

Here is one approach

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

[#3]

Regex like this might work

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

[#4]

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