cubewise-code
Best practice to import data with embedded new lines (blank lines in comments)
I’m trying to import data from excel or csv into PA. The data which is comments, is formatted with necessary blank lines
I am trying to import to a dataframe and then upload that to Pa
When I use read_csv it gets messed up on new lines into dataframe
If I use read_excel I can get the data into a dataframe and even write it to pa using Tm1py.
But when I try to display with dbrw in excel the blank lines are gone. I think perhaps only \n gets written to pa, not \r\n
What is best practice for importing data with new lines and writing to pa so original formatting is preserved?
Tm1py version (close to latest) Pa 11
Additional context If you encounter an error, please add the error message and the stack trace
Have you tried https://github.com/cubewise-code/tm1py/discussions/1228#discussion-8014076?
