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.


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


how to do this ?

See More: strip data from .CSV

Report •

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 •

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 •

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

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