tballs
Technical User
- Jul 27, 2011
- 4
Howdy... new to sed/awk scripting so hopefully I can get some assistance here.
I have multiple lines of data in a file that are comma delimited. Here is an example:
Advantage 12,5650,01/03/2011,Refinancing,4.24,144,"Conventional (Any loan other than GHA, VA, FSA, or RHS loans)","$137,300.00 ",Owner-occupied as a prin
cipal dwelling
I initially thought I would use awk to reformat into a useful data file for input into other software. In doing so I would use the comma's. However, There are commas in between the quotes(i.e. "$137,300.00 ") that is messing with my script.
How can I remove just the comma's that reside between the quotation marks?
I have multiple lines of data in a file that are comma delimited. Here is an example:
Advantage 12,5650,01/03/2011,Refinancing,4.24,144,"Conventional (Any loan other than GHA, VA, FSA, or RHS loans)","$137,300.00 ",Owner-occupied as a prin
cipal dwelling
I initially thought I would use awk to reformat into a useful data file for input into other software. In doing so I would use the comma's. However, There are commas in between the quotes(i.e. "$137,300.00 ") that is messing with my script.
How can I remove just the comma's that reside between the quotation marks?