How to remove prefix for number variables for existing records in Incident table

[Shawn33]

How to remove prefix for number variables for existing records in Incident table,
Example: usually number like INC0010043, but my requirement is to remove prefix "INC" for existing records and number should be like 0010043.  

[VaranAwesomenow]

you can write a script, algorithm below

glide record on incident

var numberstring = grinc.number

incnumsubstring = substring(take number after first 3 characters of numberstring).

set grinc.number = incnumsubstring

This will only update existing records, if you want all future records to also not have prefix, then you need to update the prefix to empty.

But may I ask why this is being attempted ?

[Shawn33]

client requirement

[Shawn33]

is that code for only one record or for all existing records?

[VaranAwesomenow]

its a gliderecord so it will apply to all records that are part of the query