How to Rearrange Order of CSV files so that Telephone # is First

3 replies
How can I Rearrange the Order of CSV files so that Telephone # is First, the first name is second and Last name is third when I have a CSV file with email first, then first name then last name and phone number si in an indeterminate location somewhere in each file after the person's address?
I have leads from 3 separate double-optin lad systems and I am trying to load them as a file into the Call-Em-All system. Any suggestions would be appreciated.
#csv #files #order #rearrange #telephone
  • Profile picture of the author ohio1975
    if i understand you situation properly: you have a CSV file and would like to rearrange the columns into the desired order? is that correct?

    if so, and the number of rows in these files can be read by your current version of your spreadsheet program, import them into the spreadsheet program, specify that you are importing a "delimited" text file, and simply click and drag the columns into the proper order. save as another csv file (assuming the final program you want to read it into takes csv).
    {{ DiscussionBoard.errors[4257299].message }}
    • Profile picture of the author wcardinal
      open the file in Excel and you will easily be able to rearrange the columns.
      {{ DiscussionBoard.errors[4257815].message }}
  • Profile picture of the author armanda555
    i am newbie
    i still don't know anything. LOL
    {{ DiscussionBoard.errors[4257834].message }}

Trending Topics