Import Comments usong CSV file

[Cristina - Elena Andrei]

Hello,

I have to import a CSV file when  i have issues with multiple comments. I made separate columns for each comment  -> comment 1, comment 2 etc. Will necessary to create also columns for Create date since the comments given the fact that the comments were added on different days? Or on the same day but the difference of seconds, hours, minutes?

Thank you!

[Laurie Sciutti]

Hi @Cristina - Elena Andrei ~ the comment date (and user) info goes in the same column with your comment and is separated by a semicolon (example below):

21/Jun/23 11:12 AM;<username>;<comment>

[Cristina - Elena Andrei]

• Thank You, the file that i have to import has already a separate column with date and time , separate column with the one who commented and another column with comment

[Tim Perrault]

Hi @Cristina - Elena Andrei 

The columns for each comment can also contain the date/timestamp with comment.

Date; AAID of the comment author; Comment

Example:

30/MAY/10 11:20; 620bxxxxxxxxxx0069601a2d; This is a comment.

[Cristina - Elena Andrei]

Thank You, the file that i have to import has already a separate column with date and time , separate column with the one who commented and another column with comment

[Tim Perrault]

Yea you will need to combine those. You could use the CONCAT function to combine the 3 columns and then take the values and paste them into a new column. Then get rid of the 4 extra columns (the original date of comment, author of comment, comment, and that function column).