Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Large CSV Files

I have a large csv file with around 80mb each. I tried to use the Folder as the data source and as soon as it combines, some of the data are note correct, such as: Some of the columns are misaligne...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

1. You can use Trim Function to trim the Columns which are misaligned.

2. You will need to Use Locale settting the Date to the correct Format.

 

 

 

 

Select Locale.

 

 

 

For Trimming and Cleaning

 

 

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak , it's always just the comma. I'm wondering if it's the file itself the problem, CSVs should be always smaller right? but when I convert it in xlsx the file size gets smaller.

 

Anonymous the problem in the misalignment is just certain count of rows not just one file is getting misaligned. Which I really find weird. I also tried using the Date Locale but it still doesn't work, what worked is that I converted the column to Text first then added a column to convert text to DateTime. I think the problem stems out really in the file itself which I don't know what it is.