I think this was discussed previously. I don't remember the solution, but try searching for chr(10) or chr(13).
We had very few parts with more than one line and solved this same problem by removing the CR/LF from the part descriptions so I unfortunately can't be of much help.
We had very few parts with more than one line and solved this same problem by removing the CR/LF from the part descriptions so I unfortunately can't be of much help.
--- In vantage@yahoogroups.com, "pklein256" <pklein@...> wrote:
>
> I have a BAQ that I want to have a calculated field and pull the first line part.partdescription out. When I copy/past from a dashboard, or export the baq to a .csv - that 2nd line messes up the spreadsheet. What is the code to have the "carriage return", line feed or whatever the character is - to separate it by that so I only pull the first line?
> Thanks,
>