Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

8
  • 1
    Hi @thinkingsavvy. Would you please double check your command. The output is different than the output "Actual output file - Test1.csv" that you had provided in the question? Commented Sep 17, 2018 at 19:17
  • Hi @Goro. You are correct! I copied the output from excel. The output using cat is. Id,Day,UserId,ItemId,MonthYear 1,12/1/17 0:03,2323,tv,12/17 2,12/14/17 7:10,4546,frr,12/17 3,1/22/18 14:11,2421,fdf,1/18 4,2/16/18 13:36,4545,dfdf,2/18 5,3/5/18 10:47,1232,dfsdf,3/18 Commented Sep 17, 2018 at 19:21
  • 1
    You are using is RSwhich is the record seperator. What you want is FS which is the field separator. Commented Sep 17, 2018 at 19:21
  • @thinkingsavvy, thanks! please try the commands below and let us know! Commented Sep 17, 2018 at 19:29
  • Your comment claims that the field separator is a semicolon (;) but the file contents posted in the question use a tab(?) or spaces(?) as field separator. Which is the correct one?. Commented Sep 17, 2018 at 19:41