There must be something in the request that indicates you want csv or tsv. If it's in the request.args, for example, something like this would work:
if 'csv' not in request.args and 'tsv' not in request.args: db.inventory.cpu_status.represent = lambda cpu_status, row: SPAN( ... On Wednesday, April 16, 2014 12:58:12 PM UTC-4, John Fraser wrote: > > Is there an easy way to strip HTML markup from SQLFORM.grid's CSV/TSV > export? I realize I probably need to create a custom export function, but > curious if there is an argument or a one liner that would do the trick. Or > is there a better way to format the display? > > I have the following controller function: > > @auth.requires_login() > def index(): > response.title = 'Computer Inventory' > db.inventory.id.readable = False > db.inventory.cpu_status.represent = lambda cpu_status, row: \ > SPAN(row.cpu_status, > _style='text-transform: uppercase; font-weight: bold; > padding:5px; color: %s; background-color: %s' % > ('black' if row.cpu_status == 'Staged' else 'white','red' if > row.cpu_status == 'Repair' else 'gold' > if row.cpu_status == 'Staged' else 'green' if row.cpu_status > == 'In Use' else 'black')) > grid = SQLFORM.grid(db.inventory, csv=True) > return locals() > > > When I export as CSV/TSV (as displayed to the user) all values for > db.inventory.cpu_status are wrapped in SPAN tags for example: > > <span style='text-transform: uppercase; font-weight: bold; padding:5px; > color: white; background-color: black'>VALUE</span> > > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.