in the database (Snowflake) I have a record that is over 20 characters long.

In order to enable this record as more user friendly, I am trying to shrink it to 15 characters only.

Basically the record is as follows:

https://id.x.com/af/a3/192501_**Z0B0000000EGZZZ**

I would like to remove all these first characters: https://id.x.com/af/a3/192501_

Please note the records are different in the db hence I cannot simply use only this single record

Should I use select regexp_replace or any other functions?

Thanks