Subject ID "RIGHT" function

Phoenix Certara Forums Phoenix WNL basics
1

in data wizard:

  • for subject ID “1001-0001”, how do I remove the left 5 characters (“1001-”). (subject ID is a text column)

When I did a “RIGHT (ID, 4)” in phoenix, I got “1”, instead of “0001”. (the front leading zeros “000” are ignored).

thanks

2

Hi rxz,

You used the RIGHT() function correctly, but the software automatically typecasts the “0001” string into an integer. Simon has a good idea in this post:

https://support.certara.com/forums/topic/646-issue-with-leading-zeros-taken-from-a-text-entry/?hl=leading

Alternatively, you can send us an email to support@certara.com with just the subject ID column and I can covert it for you.