Cols utilities: how to let take care of empty data?
HiI got a problem when using Cols->utilities->text to columns.For example I have data 1, ,2,3, after doing text to columns, I want to get {1},{ },{2},{3} these four columns, while JMP gives me {1},{2},{3} as below screen shot.Excel can do this with <Text to Columns>Is there an solution out there in JMP? The result I got from JMP:what I expected: