CSV Max Size in Field RRS feed

  • Question

  • I am working with a .csv file where the data in one of the fields has too many characters for what I am using it for. I need to take the first 10 characters of text from that field and repopulate the field within the original csv, or manipulate the relevant field and export that, along with the rest of the data to a new .csv. For example:

    Original .csv has 5 columns (1,2,3,4,5). The data in column number 3 for some of the rows has too many characters. I need to take the first 10 letters of each entry in column 3 and save that to the original .csv, or i can take the manipulated data from column 3 and the data from the other columns and create a new .csv. 

    Thanks for any help.

    Monday, August 28, 2017 8:24 PM

All replies