Recent content by pho01

Cool! Thanks!

One column of my spreadsheet, I have this data extracted from a database in this format: Column C1: ["Name","Street Address","City, State Zipcode"] I want to extract Street Address, City, State Zipcode into a different column, N1. How do I do that? Thanks!

thank you ehaze, I customize the forms in Infopath, add rules, etc... everything is working in the preview of Infopath, but when i published the form to Sharepoint 2010, the rules are not working. Click customize form again to check it in Infopath, the rules are still there...and working in...

In Sharepoint, I need modify a new item form of a list to make a field visible/invisible when a check box is selected: For example: There is a checkbox field called "Is XYZ affected?" When a user selects this field, it will make a hidden field visible "Impact details:" If "Is XYZ affected?"...

I have data for the whole fiscal year, for example: Nov Dec Jan Feb Mar Apr... 12 Dec, Jan, Feb, Mar and Apr columns have none data, how do i use one formula to calculate the average up to date. For example, average would be 12 for the data above, not 12/12 (whole year) = 1...

Thanks ClulessChris. It worked

I have a spreadsheet with thousand of rows. I combine values of all columns of each row into one column K. Now I want to export each row of column K into a text file. For example: Sheet1.Cells(1,"K").value => C:\temp\1.txt Sheet1.Cells(2,"K").value => C:\temp\2.txt Sheet1.Cells(3,"K").value =>...

On my Excel macro, I had: Set r1 = Sheet1.Range(Cells(2, 1), Cells(1000, 3)) Step into the code, it returns error Run-time error '1004': Application-defined or object-defined error Any idea why it is complaining that? FYI: This is regarding to testing the script on the posting...

Thank you both for your response. GlennUK response worked great!

I have a spreadsheet like below. For each month, it has 3 columns, EMEA, NA, and AP. Under those columns, they have several rows as well, like Core Planned, Core Unplanned, Non-core Planned, Non-core Unplanned. We have a whole year data, and i want to create a section that looks up the data...

I know, just don't know what the pattern should be for non-ascii? or non english characters.... there're lots of non english characters out there, can't capture them all...

How do I replace any non ascii characters with a question mark? (?) We have xml interface to submit incidents in, and it doesn't accept any non ascii characters. I want to replace all non ascii chars with a (?) before submitting? Anyone knows the search pattern for non ascii char? or Perl...

sorry, it's business objects. thanks for tips

Can Businessobject link data from one table to a different table? just like in Excel? =Sheet2!B9 =B1 etc... Thanks!

What is the right format to compare date in BusinessObject, I tried to create a varable, similar to: =If([Currently Open].[Incident Closed Date]>"04/30/2008";"May";"") and =If([Currently Open].[Incident Closed Date >04/30/2008;"May";"") Both failed: The expression/sub-expression at position...