Search found 4 matches

by hemashah
Wed Jun 10, 2009 10:55 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: change last digit of numeric fields based on rule
Replies: 3
Views: 3419

Re: change last digit of numeric fields based on rule

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.
by hemashah
Wed Jun 10, 2009 10:37 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: change last digit of numeric fields based on rule
Replies: 3
Views: 3419

change last digit of numeric fields based on rule

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 ...
by hemashah
Wed Jun 10, 2009 12:07 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: format numeric field in format
Replies: 3
Views: 3152

Re: format numeric field in format

Hi,

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



Thanks,
Hema.
by hemashah
Tue Jun 09, 2009 2:46 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: format numeric field in format
Replies: 3
Views: 3152

format numeric field in format

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.