Manage length of field values

Question

Hi All,

How to adjust the value lengths of a column in the data frame? My dataset has a column weight which has floating-point numbers. I want to have the same length of values for this field. Is it possible to manage the length without round off or truncate?

Answer 1

Hi,

Use str_pad() function to format the length of field values (string type).

Syntax: str_pad(string,width, side = "left/right")

To use str_pad(), convert the numeric field to string and then back to numeric after padding.

Ex:

> c = c("1","10","3","4","50")
> c
[1] "1" "10" "3" "4" "50"
> str_pad(c,2,side = "right",pad = "0")
[1] "10" "10" "30" "40" "50"