strip data from .CSV

July 29, 2010 at 09:12:32
Specs: Windows XP
hi there, i have a CSV file where i need only the second column.
but thats not it....

the second column contains fx.

000000019032

i want to remove all the zeros in front of 19032 and instead put a "p" in front of it

so the results from this would be

p19032

how to do this ?


See More: strip data from .CSV

Report •

#1
July 29, 2010 at 11:06:21
That's inpossible it can not do both of those but u may find a program that can. Cmd can't change fx valves.

Report •

#2
July 29, 2010 at 12:39:09
What's an fx value?

When your only tool is a hammer, every problem looks like a nail.


Report •

#3
July 29, 2010 at 13:23:47
sorry with fx, i meant example values

anyways, i have discardet the batch method, i found out how to make it in a vb script which is fine by me ;-)

but thx for your replys


Report •

Related Solutions

#4
July 29, 2010 at 18:18:32
download gawk for windows(see my sig), then use this one liner

c:\test> gawk  -F"," "{print $2+0}" file

GNU win32 packages | Gawk


Report •

Ask Question