Hello guy, so i'm new to OutSystems, i need your guy help on thisSo i was making an Excel to CSV convert on Reactive web app. It's simple as you upload an Excel file then a CSV file will be available to be downloaded. But i got this issue, i wanted to upload an excel file with the format with 2 record will be inside a single cell, but the output is an CSV file with each record on a different cell. The forge i use is CSVUtils and Excel tools
So i think the problems might be because of the ConvertToCSV function that belong to the Excel tools forge that cause the error, so i need you guy help on this, how do i fix it? Thanks
Please open the CSV file in the notepad and you can see like below
ConvertExcel takes the value of the respective cell and places it inside the CSV. Since the value contains a newline, it is treated as a new record in the CSV. Try adding values in columns B, C, and D, and you will see that those values shift to a new row.
In one sense, it is working as expected—moving the cell value from Excel to a column in the CSV. However, if there is a newline, it will be treated as a new record. One option is to replace the newline with another separator before converting to CSV.