Removing Extra Line Breaks from a field in CSV file
Posted on 2011-03-02
I have a CSV file that was exported from a Goldmine database and I am attempting to import into another Goldmine database.
There are roughly 30ish fields that are exported with field headers.
One of the fields in NOTES. In the notes field, there are line breaks/returns that break up having each record on its own row. I have to bring into Crystal Reports and then export to be "Goldmine" Friendly.
The problem is that it's reading these line breaks and screwing up all the data - there are roughly 90kish records so this isn't something I can go and fix manually.
How can I go about removing the line breaks just in this NOTES field before bringing it into Crystal Reports?
NOTE ADDITIONAL: This notes field has html code for formatting that the version of Goldmine I am importing into can't support anyway. If I have to delete the NOTES column altogether I might have to, but I have no way of accessing that column due to the fact the line breaks push data into other columns!