Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: philk12
  • Order by date
  1. philk12

    maximum width occupied by a value

    How do I find out maximum width occupied by a value in a column in an XL sheet? I dont have specs(lengths of fields) to build a table, I'm manually evaluating each column length by going through data in the xl sheet.
  2. philk12

    C Question,

    Sorry if this is not the C forum, but couldn't find C only C++. I have procedures where the first two parameters are alternates, i.e.values must be supplied for param1, param3, param4, etc or param2, param3, param4, etc However I need to call some of these routines from some legacy C code...
  3. philk12

    Special characters problem

    it worked finally! But just one thng how do I replace special characters. Do I have to copy them from xl sheet and paste in my script below.. is there any automated way of removing any special characters? Thanks Private Sub Worksheet_Change(ByVal Target As Range) For x = 0 To 9...
  4. philk12

    Special characters in Excel

    )I right clicked on sheet1 and wrote this macro. 2)I came to XL sheet, clicked record new macro by giving name Macro1 3)i stopped macro recording 4)i ran the macro but nothing has happened. Tell me is it something wrong on what Iam doing. This is same I ve been doing from yesterday night but was...
  5. philk12

    Special characters in Excel

    Thanks very much for all the pointers. I am attaching my xl sheet with just the only column I require. FIRST_NAME has got digits,quotes,dots,special characters etc, I need to remove them and have only characters from A to Z(first_name obviously does not contain letters other than A to Z )...
  6. philk12

    Special characters in Excel

    I copied the source you sent but dont know what to do next. Iam just failing to save as macro and run it further. Just new to XL sheet modifying..... Can you tell me what to do once after I paste that script?
  7. philk12

    numberic field checking

    Yes that is very cool, Jimbo. Thank you all for your kind assistance. Philky
  8. philk12

    Special characters in Excel

    Skip, yes this is true, but how would U automate this? Thanks, Philky
  9. philk12

    Special characters in Excel

    I have an XL sheet with 6 fields..Im converting xl into a table. Among 6fields, 2 fields have problem i.e. first name(field3) and last name(field4) have got special characters & digits & quotes & slashes & #... I got to remove them & should have only alphabets from A to Z in first & last...
  10. philk12

    Help creating XML-Schema

    All I'm quite new to XML and maybe there is a chance that I do not fully understand the way I am supposed to do this. I generate a XML-Schema and puts it in another project. When I generate the schema I get following Character field sample <xsd:element name="FIELD1">...
  11. philk12

    setting reminders in MSN outlook

    Are there API's for setting reminders in MSN outlook from the other platoforms?
  12. philk12

    numberic field checking

    We are converting data files and we want to test invalid numeric data errors in our converted files. What is the best way to do so? Is there any scalar function that returns NULL if the content of a numeric field is invalid? Thanks in advance for your help
  13. philk12

    Delete from question

    Hello, Is this the correct way to write an embedded sql "DELETE FROM" statement with a wildcard? delete from xxx where ACITY not like :BCITY || '%'
  14. philk12

    creating a file via SQL

    TableA Order number 2001 Item number 000001 Quantity 20 Category 0 Sub category 0 TableB Row Row Item number 000001 000001 Category 0001 0094 Sub category 0010 0026 TableC would contain the following rows...
  15. philk12

    creating a file via SQL

    Morning all I am giving myself a headache in trying to solve a problem with SQL I've tried looking through the archives, but I am not really too sure what I am looking for. Anyway, if anyone can help me, The problem is as follows:- I have 2 files, in their simplistic form FileA Order number...
  16. philk12

    Basic Subfile update code

    HI I am used to doing a subfile update having the user place an X next to the line they want to update and then displaying this record on a separate screen, allowing the update. Now I have to allow them to directly change the data on the line I am not sure of the code sequence. Perhaps...
  17. philk12

    Java String Length

    How to dermine the (string) length of this declaration: // File Name object D fileNamex S O Class(*JAVA:'java.lang.String') // trimmed File Name object D tfileName S O Class(*JAVA:'java.lang.String')
  18. philk12

    SQL ROUND function on a FLOAT

    This isn't so much a question but more like a "what the?!". If I have the float value "3.4173900000000001E+000" and issue a "ROUND( 3.4173900000000001E+000, 2 )", I get (drum roll) 3.4199999999999999E+000. Cast as a dec with 2 decimal places and viola! You get 3.41739 rounded to 3.41. This...
  19. philk12

    Workbook Problem w/ HSSD_Open Fails

    The path and file name is: '/bq_budgets/inbound/Salesman/B7_Slm_S001_JOHNSMITH_QQ.xls'. All workbooks for salesmen were created in one run and all given a single group-sequence-number (001, in this example) in my control file. (Each salesman workbook created in the run has it's own unique...
  20. philk12

    Running Excel workbook 'inbound' function

    The question: When running the workbook 'inbound' function, if there's a failure in the "book = HSSF_open(file_name)" loop because a given workbook in the group doesn't exist in the path, then no 'open' works after that even though subsequent workbook(s) in the group do exist. The monitor group...

Part and Inventory Search

Back
Top