SharePoint Designers

All about Branding & Customizations in SharePoint

Hi,

 

So this time I have a problem with a data view that is quite large contains around 3000 items. The data view works just fine, and contains items from 5 different lists.

 

But my problem is that all the numeric fields contains a dot instead of a comma. Since I need to export all the data to Excel I don´t want the comma, because in Excel I can´t use the data if I want to make an graph etc.

 

I dont want to customize the whole page in Sharepoint Designer since that would require a lot of work.

 

My idea was to try and add jquery to the page and find all the dots and change it to comma instead.

 

I tried this script below, but that removed also the numbers.

 

$(function(){

$("TD.ms-vb2:contains('.')").html(',');

});

 

Does anyone with more jquery knowledge have an idea how to get this to work?

// Jenny

Tags: DataView

Views: 108

Reply to This

Replies to This Discussion

HI Jenny, I did some similar for a while ago, and I used string replacement with jQuery, you should be able to replace a specific character or all characters (or words), check out the DOM replacement sections http://api.jquery.com/category/manipulation/dom-replacement/ in jQuery API. Another way is of course to replace what you need in excel afterwards. Let me know if you fix this, otherwise I can give it a try.
/ C

Reply to Discussion

RSS

Birthdays

Birthdays Today

Birthdays Tomorrow

© 2012   Created by Christian Ståhl.

Badges  |  Report an Issue  |  Terms of Service