How to obtain raw field value from db table in a view?
One of the last things Views does when it renders a view is to process all the fields raw data and format them according to settings, then theme according to the default or your own custom views templates.

So, if the 'Output format' options in field's settings on the view don't provide what you need, you can get the raw values - before formatting &amp; theming - like so:


Install Views PHP so you can run code from within views fields, arguments etc.
Check the "Exclude from display" option on the fields you want 'raw' to stop them appearing in the output, but still ensure they're in the view data.
Add one "Global: PHP" field for each field for each hidden field.
In the "Output code" at the bottom of the field settings on the new Views PHP field, add something along the lines of print $row-&gt;field_you_want_raw.


Since you've got full PHP in these new fields you can format, tweak and merge any raw field data you need.