I am having problems sorting everything correctly from identity safe. Can some one help?
What are you trying to sort? How are you viewing the csv file?
I have opened it up in an Excel but can't figure out how to sort all the data. I tried in Notepad but that made no sense. I know a little about Excel but don't work with it all the time. Any help would be great.
I believe it starts like url,username,password,name,grouping,extra
the next several lines are data matching above in CSV ex. http : / / helpme . com, Iam,password,iam2, you get the picture. Any suggestions on how to sort data like this?
You need to use the data formatting features of Excel to do this. Use the Excel Help function to figure out the process.
The following info may be helpful:
I think cmedina is trying to format the output in Excel in a different order than it is presented from the csv file. Maybe alphabetically???
I know it can be done with Excel, but I have not done it for many years now, so I would only be quoting the Excel help files.
This is how it should be done. Trust me it took awhile to figure this out.
In Excel, create a new workbook. Then select the Import option from the Filemenu.
A dialog box will pop up. Make sure CSV file is selected and click the Importbutton.
You can now select your CSV file from where you have saved it.
In Excel, you will now be asked to confirm that your data is delimited. That is, your CSV file is filled with data separated only by a comma. Excel should be able to automatically tell that this is correct. Now click the Next button.
In Excel, you will now be shown a preview of how your data will be sorted into columns, based on the fact that your data is separated by commas, and text items may be enclosed in “inverted commas”. Check the data preview, and select or deselect delimiter options and text qualifier options until the preview reflects how you expect the data to look. In most of these cases, this will be chosen for you automatically. For example, Excel will know that all text data has a text qualifier of inverted commas, so it will let you know it plans to remove the inverted commas when it imports the data. When you are happy with how the data will be imported, click the Next button.
In Excel, you will now be asked to select what type of data is in each row. Select General for all columns now (we will customize each column of data after it is imported). Double-check the advanced setting to ensure your data reflects standard conventions for numbers in their thousands and for decimal places.
So depending on your original data source, you may need to change these settings.
Now click the Finish button to import the CSV data into your Excel spreadsheet.
If you are experiencing an issue that needs urgent assistance please visit our customer support area:
There are currently 2 users online.