How to collect the right 3 characters in a string?

Which node I should use, and how to convert a string “00123” to “123”?
like we can use funciton: right(“00123”, 3) in excel.

Actuallly, my purpose is to make the following string from
… …
984
994
4
14
24
… …

to
… …
… …
984
994
004
014
024
… …

so I’m considering to add “00” to each string, and then collect the right 3 characters.

Hi @qianyi , you can use the String Manipulation Node and enter the syntax

padLeft($column1$, 3, "000")

where column1 is the name of the column you want to manipulate.

1 Like

That is a good idea @qianyi :slight_smile:
Also there is a solution button behind 3 dots in bottom right corner of each replay which marks replay as a solution to a topic. And keeps our community forum a fraction tidier :wink:
Br,
Ivan

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.