Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Programming > Remove preceding zero's of all numbers

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Remove preceding zero's of all numbers

Reply to Message Icon

Name: onegreenparker
Date: September 10, 2009 at 09:57:20 Pacific
OS: Windows XP/Server 2003
Product: Microsoft Windows server 2003 enterprise
Subcategory: Batch
Tags: batch, zero, preceding, remove
Comment:

I have a .csv file with several columns, variable width, variable content. All number field have preceding zero's (variable number of zero's), the zero's need to be removed in order for correct merging of data in two separate files.
Can anyone point me in the right direction to remove these offending zero's with a batch file?



Sponsored Link
Ads by Google

Response Number 1
Name: dtech10
Date: September 10, 2009 at 16:26:38 Pacific
Reply:

Hi onegreenparker

What is the delimiter a comma or some other charactor.


0

Response Number 2
Name: Wahine
Date: September 10, 2009 at 19:06:03 Pacific
Reply:

How many columns and which fields are always numeric?


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


setting up dual boot Scripts to search for a t...


Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links
Ads by Google


Results for: Remove preceding zero's of all numbers
Bat Time kepper www.computing.net/answers/programming/bat-time-kepper-/17047.html

Remove top 6 lines of a text file www.computing.net/answers/programming/remove-top-6-lines-of-a-text-file/19324.html

Remove sys tray ICON of VNC www.computing.net/answers/programming/remove-sys-tray-icon-of-vnc/17921.html