R
RJF
I have a table that contains one field. I will be breaking this field into
several other fields by replacing the commas with semi-colons and then
exporting the table to a text document.
The problem I'm having is when there are any commas within quotes, as shown
below. How do I remove these commas before I replace all the other commas
with semi-colons?
Below is a sample row containing the extra commas. There are three fields
here.
333371,"http://maps.google.com/maps?+Broadway,+Providence,+RI+",JRaposo,
The row should look like this before I replace the commas with semi-colons.
333371,"http://maps.google.com/maps?+Broadway+Providence+RI+",JRaposo,
I know it probably doesn't make sense that I'm changing the commas to
semi-colons. It was an attempt to solve the commas w/in quotes problem (long
story). I could remove the step of replacing the commas with the
semi-colons, if I could just remove the commas between the quotes.
I hope I've made that clear enough. Any help would be so much appreciated.
Thank you,
several other fields by replacing the commas with semi-colons and then
exporting the table to a text document.
The problem I'm having is when there are any commas within quotes, as shown
below. How do I remove these commas before I replace all the other commas
with semi-colons?
Below is a sample row containing the extra commas. There are three fields
here.
333371,"http://maps.google.com/maps?+Broadway,+Providence,+RI+",JRaposo,
The row should look like this before I replace the commas with semi-colons.
333371,"http://maps.google.com/maps?+Broadway+Providence+RI+",JRaposo,
I know it probably doesn't make sense that I'm changing the commas to
semi-colons. It was an attempt to solve the commas w/in quotes problem (long
story). I could remove the step of replacing the commas with the
semi-colons, if I could just remove the commas between the quotes.
I hope I've made that clear enough. Any help would be so much appreciated.
Thank you,