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!

Register Log in
  • Congratulations derfloh 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: *

  1. PureSoft

    Problem with <SELECT> not appearing the same in IE & Firefox with CSS

    Hi, I'm trying to do a simple drop down, styled by CSS which looks uniform in IE and Firefox. Here is a sample page www.puresoft.co.uk/select.htm. For some reason the Firefox browser seems to want to make the drop down have a 3D border. How can I remove this look, so its flat, like the IE...
  2. PureSoft

    Using MSComm to import text strings

    Guys, Thank you for your replies. The input string is about 50 characters long. I'm trying to interface a PIC microcontroller. I have comms going from the PC to the PIC, but not the other way around. I have done some further tests and it appears to be an issue with my string input not being...
  3. PureSoft

    Using MSComm to import text strings

    Hi, I have written some code which seems to trip up, can anyone tell me why this deosn't work? input_string = MSComm1.Input input_string_holder_array = Split(input_string, ",") Label1.Caption = input_string_holder_array(2) It seems that when the array value is passed over to...
  4. PureSoft

    type mismatching - how to format strings as numbers for assigning

    ...then coupled with the Round() function that does what I need. Here is an axample for anyone interested. Dim order_total As Double temp_hold_values() As String order_total = order_total + (Round(Val(temp_hold_values(i)) * Val(temp_hold_values(i + 1)), 2)) 'The running total order amount Philip.
  5. PureSoft

    type mismatching - how to format strings as numbers for assigning

    ...Dim order_total Dim hold_values() As String order_total = FormatNumber(order_total, 2, , , vbFalse) + FormatNumber(hold_values(i), 2, , , vbFalse) * FormatNumber(hold_values(i + 1), 2, , , vbFalse) 'The running total order amount What should I do with the declarations of the variables, or...
  6. PureSoft

    filling an array with lines of text

    I just re-read the variable declaration help and see that variables on the same line, separated by commas, do not get the same type as the last defined, rather they get the default variant, unless specifically defined otherwise. I didn't realise that was the case, thanks for the info, I'm on my...
  7. PureSoft

    filling an array with lines of text

    Thanks, Thats gotten me a couple of lines further :-) However I'm now having problems with assigning this captured line from the array to another array (filling it with the split up values form the original line of text), I'm getting type mismatch error for the last line shown: Dim strStripped...
  8. PureSoft

    filling an array with lines of text

    sorry, its defined as: Dim Line_holder_array() As String
  9. PureSoft

    filling an array with lines of text

    Hi, I have a simple loop that seems to cause problems with 'subscript out of range' - I want to read in a text file, line by line and fill it into an array for subsequent reference. Here is the code: m = 0 While Not EOF(1) Line Input #1, Line_holder_array(m) m = m + 1 Wend What's my...
  10. PureSoft

    Hidden white space characters?

    vb5prgrmr, Thanks so much - I was trying something along those lines, but was getting muddled how to structure things properly. I ran the code and had to add just one extra line under the replace line of code section of S = Left(S, (Len(S) - 2)) to chop off an extrs vbNewLine character that it...
  11. PureSoft

    Hidden white space characters?

    Hi, I'm really not getting anywhere :-( I can't seem to open the file read through it and replace the characters as required. I used ultraedit to view the files and see its because I don't have the carriage return character in my csv, just the line feed, that's tripping my routines up, so I...
  12. PureSoft

    Hidden white space characters?

    Hi, I have a csv export file (from a shopping cart system) that when processed raw, gives problems because the end of line character does not appear to be right. It will view fine in Excel, starting new lines as supposed to, its just that when I use the 'Line Input' command on the raw file it...
  13. PureSoft

    Detecting a string value as a number or text

    Thanks Tom, That does the trick! Philip
  14. PureSoft

    Detecting a string value as a number or text

    Hi guys, I'm sure this should be an easy one for you, although I couldn't find an example in some searches on the forum. I have a csv file (from a shopping cart export) I've split up and read into an array holding these values as strings. What I want to do now is test some of them to see if...
  15. PureSoft

    Working with CSV files - importing > manipulating > exporting

    ok, got it sorted out. Used the string '&' function to concantenate my array elements together, adding in the required formatting for the csv. Needed to use the Print command as opposed to the Write command. Here is the working code for anyone else dropping by: Private Sub Command1_Click()...
  16. PureSoft

    Working with CSV files - importing > manipulating > exporting

    John, Thanks again for replying, but I want to be able to write record by record (or alternatively a line at a time created from my cusomised records) becuase I'm going to have to insert custom fileds that I'm creating dynamically from the original file content - I'll be doing things like...
  17. PureSoft

    Working with CSV files - importing > manipulating > exporting

    John, Thanks for the reply, and the example using the direct access of Excel, though I'm wanting to do it avoiding the need for Excel to be installed and resident on the host PC, since I will want to offer this finished conversion utility to other users who have the same shopping cart system...
  18. PureSoft

    Working with CSV files - importing > manipulating > exporting

    Thanks for the pointer. I have now got the basics nearly there, though I am still having two problems: 1) I am using the write statement, reading from the array, but the field outputs from each line are placed on successive lines, rather than one long line - see snippet below. What ways are...
  19. PureSoft

    Working with CSV files - importing > manipulating > exporting

    Hello Guys, I have a website order export as a raw csv file with the various fields one after the other, with a separate line for each order. I want to read in that file, assigning each field to a variable so I can analyse those variables and then do some manipulations, before finally exporting...
  20. PureSoft

    Evaluation of 'document.form_name.select.value' in Netscape 4?

    Yes! That works wonderfully. Thank you so much. I had almost given up on it! Rick, send me an e-mail so I can send something to you... Regards, Philip Hodgers. philip@puresoft.co.uk

Part and Inventory Search

Back
Top