Editing CSV Parameters [BIME TIP]

Sometimes you just want to analyze data stored in Text Files. Bime gives all the flexibility you need to extract from any CSV and flat files that you may encounter.

Click here to see the list of data sources that bime connects to!

When you connect to a CSV file, you'll need to edit the parameters to make sure bime reads the file properly.

Here is a step by step on how to do this.

First of all, you have to create a CSV connection.

Then, just follow these steps:

1) Choose a file, you can choose any kind of extension

The CSV/flat files connector only works with Bime desktop except if you are using the "Déjà Vu" cache and reloading an existing pivot table.

2) Edit parameters

Once you choose a file, just edit the parameters (for instance, decide if you want to process a CSV or a flat file and choose all the specific parameters).

CSV parameters popup

If your file headers are NOT embedded in the first line, you can easily edit your own headers. If you uncheck the "Line 1 is headers" checkbox, it is possible to specify your own headers. Then, the CSV tab asks you to determine some parameters, such as the recordset delimiter, the separator etc. If you are French and using a French date in your file, please select the "French dates" checkbox. In a same way, if you are using a comma instead of a decimal point for your numbers, change the default value in the "Float separator" field.

The text in your file should look like this if you use the first line as headers.

Flat file parameters

If you select the "Fixed Width" tab, you will be able to define parameters for a flat file. As you can see on the illustration above, there are two possible formats: a fixed length and a variable fixed length format. If you check the "Columns have Variable Width" box you implicitly choose a variable fixed length format.

3) The preview

In order to validate your choices, you can use the preview button which enables you to see if the connector will correctly parse your data. This ensures accurate processing.

4) Save your data source

As you can see for all other data sources, the final step is the same: save the data source and generate the data schema. You can then modify the schema and save it. Then just load it to the pivot table and begin to manipulate your data.

I hope this answers any CSV connection questions you might have! Don't hesitate to talk to us if you require any bime support.