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*

5
  • Welcome! You have not specified what should happen if the first field contains more than one character. Should it be simply removed (this would make things out of alignment) or should the characters be replaced by spaces? Also, please take a minute to read the tour page so as to familiarize yourself with the website. Commented Jul 30, 2020 at 20:34
  • yess sorry . the first filed contains some word in column 1 who are repeat .i would like remove (space) the repeat word but without change the other columns.i' ve find to remove repeat word but it remove azll the line or it change the alignement... Commented Jul 31, 2020 at 9:17
  • Please notice that two fields are gone in the 2nd line (i.e., two , disappeared). I don't think that's what you want, check it out. Also, share with us what you tried. It does not matter if it failed, but we can give you a solution closer to your attempt and show you why it failed. Commented Jul 31, 2020 at 11:26
  • the double commas are an empty columns for completed later... Commented Jul 31, 2020 at 12:34
  • Are all lines with the same value for the first column consecutive, or can a value found "further up" in the file reappear further down in the file, after several lines with a different value for the first column? Commented Jul 31, 2020 at 12:41