DataMystic

What pattern match can I use so that it checks for +ve and -ve numeric fields?
How can I check for last digit only and replace last digit with predefined character.

Thanks,
Hema.

Hi, I have csv file. I need to replace last digit of numeric field with the following sample rule: Replace last digit with { when last digit is 0 and it is +ve no Replace last digit with 1 when last digit is 1 nd it is + ve no Replace last digit with a when last digit is 1 and it is -ve no. How can ...

Hi,

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



Thanks,
Hema.

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.