PDA

View Full Version : Extract data in filter format from CSV file



karthikin
12-15-2011, 08:32 AM
Hi Guys, I'm new to VBA & I never worked with this language. I just started learning some Macro in VBA.

I have CSV file & I want to remove the ( " ' , )these kind of special characters from this file and classify the data in specific order.

How can i do this with macro using VBA, please help me guys :help .

This is the data from csv file:
Computer Name,"Computer Serial","User name","Employee Number","Software name"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"Microsoft .NET Framework 1.1 Security Update (KB953297)"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"IBM iSeries Access for Windows"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"E3 Graphics Base"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"IBM Software Delivery Center Client and Agent"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"Désinstallation du logiciel IBM"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"Correctif Windows XP - KB867282"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"Correctif Windows XP - KB873333"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"Correctif Windows XP - KB873339"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"Correctif Windows XP - KB885250"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"Correctif Windows XP - KB885835"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"Correctif Windows XP - KB885836"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"Correctif Windows XP - KB886185"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"Correctif Windows XP - KB887742"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"Correctif Windows XP - KB888113"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"Correctif Windows XP - KB888302"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"Mise Ã* jour de sécurité pour Windows XP (KB890046)"
DK6914XP0001,L3W8756,"LAFFAY Jeremy",1028149,"Correctif Windows XP - KB890047"

karthikin
12-16-2011, 05:32 AM
I have fixed this!!