format numeric field in format

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

hemashah
Posts: 4
Joined: Tue Jun 09, 2009 2:40 pm

format numeric field in format

Postby hemashah » Tue Jun 09, 2009 2:46 pm

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.

User avatar
DataMystic Support
Site Admin
Posts: 2136
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: format numeric field in format

Postby DataMystic Support » Tue Jun 09, 2009 11:14 pm

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

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

hemashah
Posts: 4
Joined: Tue Jun 09, 2009 2:40 pm

Re: format numeric field in format

Postby hemashah » Wed Jun 10, 2009 12:07 pm

Hi,

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



Thanks,
Hema.

User avatar
DataMystic Support
Site Admin
Posts: 2136
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: format numeric field in format

Postby DataMystic Support » Wed Jun 10, 2009 2:24 pm

Sorry - use Filters\Add\Right justify in width
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 1 guest