Search results

Hi, I have a folder on a shared drive that contains .xml files (created by various users in Excel 2007). The contents of these files (with different names) contain data regarding tracking/progression of user requests on a SharePoint 2007 list. Once a request is created by user 1, an xml file is...

You are an absolute genius!!! thank you, works like a charm :-) take care

No problem :-) for Rec# 3 it should return 0

GREAT! Thanks!! :-) this works perfect for the records with only 3 values...

hey again, no, the data shown is for 1 record only... here a few records CountryDetails Rec#1: 6;3;2 Rec#2: 12;112;0;56;41 Rec#3: NULL Rec#4: 1;101;5;16

Hey there, thanks, but I guess this works if the values are stored in different fields only?? the content in my textfield appears exactly as mentioned above: Fieldname: CountryDetails Content: EU=6;CH=3;CN=2 complete with '=' and ';' I have played around with deleting the country and '='...

Hi, I have a textfield with the following data: EU=6;CH=3;CN=2 How can I sum the values -> 6+3+2 and update a new field with the sum total? thanks!

Hi, No, the table is used to run some stats - currently the CharSet field does not exist in the download, it was created by me to determine the language of the Supplier Name. I then need to update the CharSet field (created by me) to provide info to the various data owners so they will have a...

Hi, I have a table with suppliers. The supplier name is often typed in non-latin characters - for instance Greek or Russian. I want to update another field "CharacterSet" with either the code of the character set used or text "Latin"/"Non-Latin" SupplierName CharacterSet...