format numeric field in format

[hemashah]

Hi,

I have an excel file. I need to format few numeric fields in predefined width, by adding prefix as 0. How can I do it using textpipe.

I have converted file into csv.

Thanks,
Hema.

[DataMystic Support]

Use Filters\Add\Pad to width and then search/replace spaces with zeroes.

[hemashah]

Hi,

Pad to Width filter adds space at the end of the column.



Thanks,
Hema.

[DataMystic Support]

Sorry - use Filters\Add\Right justify in width