1 reply to this topic

[rxz]

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

 

[jennyl]

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.cert...try/?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.

Edited by jennyl, 28 November 2023 - 01:21 AM.