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 Rhinorhino 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. Vatchunter

    Unusual Porblem with Fox Pro 9 Opening

    Thanks for your responses! Forwarded them onto my co-worker, let you know what he finds. vatchunter
  2. Vatchunter

    Unusual Porblem with Fox Pro 9 Opening

    Hi All, A co-worker is having problems when he opens VFP 9. This situation just started out of the blue one day... When he double clicks on the icon to open VFP, it appears like the program opens up, the icon for VFP is showing in the task bar, but not showing on the desktop. He has to then...
  3. Vatchunter

    Is there a Mid Function (Excel Term) in VFP9?

    Appreciate all you replies. tbleken that was exactly what we needed! Thanks for giving me the alternatives solutions, with the GetWordNum() and following with a Substr() would have gotten me the vast majority of what I needed. It's a good day when you can say you learned some new tricks...
  4. Vatchunter

    Is there a Mid Function (Excel Term) in VFP9?

    Thanks for the quick response. The one thing that is consistent in the return I need is: the 1st character before and the 1st character after the decimal. The number of characters and or the use of the space will vary in the data. Thanks,
  5. Vatchunter

    Is there a Mid Function (Excel Term) in VFP9?

    Hi All, I have a couple of instances where we get data that has been concatenated into one field. We need to strip out certain info but unfortunately, the characters we need to gather out of the string are not located consistently in the same place. Here's an example of the data: 6-25 4.1L...
  6. Vatchunter

    Open multiple views of tables into multiple work areas

    subscribe
  7. Vatchunter

    Font Questions

    Mike, You are correct, I am working in the Browse window. I have found that I can set the font for each table manually as you described above. Thank you for the Browse Font suggestion, once I find a preferred font, I may add that to the program that opens an sets up my tables. Have been using...
  8. Vatchunter

    Font Questions

    Hi all, I have a two part question. I spend hours each week in my data, with 8-10 tables open doing research. Do you have a font preference that you feel is easiest to read? I've been using MS San Seriff, set on (8)font size to fit everything on my monitors. I thought I would be able to change...
  9. Vatchunter

    Inserting the Date into a Character String

    Thanks Olaf, this code is just to populate a "source" field within the file that my program opens, and sets up for further evaluation. Appreciate the quick responses. vatchunter
  10. Vatchunter

    Inserting the Date into a Character String

    Thanks Mike! worked perfect!
  11. Vatchunter

    Inserting the Date into a Character String

    Hi all, How is the best way to capture the date and insert it into a character string? Basically, this is going to be a combination of the source of the data, and the date the my program was run on it. The result I need is this: "File Source 03/11/2015" Thanks for all your help!
  12. Vatchunter

    Convert number fields to text in Fox Pro 9

    Thanks! I will try to update you on what was found. Again, Thanks for all your help!
  13. Vatchunter

    Convert number fields to text in Fox Pro 9

    Hate to ask, but I'm hurting for time... how would I go about using ASC? Is this an ASCI format?
  14. Vatchunter

    Convert number fields to text in Fox Pro 9

    Olaf, Our data comes from many different sources. Not sure how long we have been experiencing this problem, but we just found it... one of the data sources had the invisible spaces in it. So the result was data from 2 different sources... in both tables that looked the same, but the program(s)...
  15. Vatchunter

    Convert number fields to text in Fox Pro 9

    Looks like the CLEAN function in Excel removed the invisible spaces that were causing me problem in this instance.... Sorry there were some typo's in my command in the previous post. Yes the value of ABC is built on the command: REPLACE ALL ABC WITH...
  16. Vatchunter

    VLOOKUP Issues

    Mintjulep, You might have found the ticket! On the test group I was using I did the Clean Function, (No Change) in result, followed with Text to Columns in both worksheets and it worked! Will work on the actual files later this evening or tomorrow morning. Will post the outcome. Thank you both...
  17. Vatchunter

    Convert number fields to text in Fox Pro 9

    Been battling an issue with an Excel 2010 VLOOKUP, decided to create the 2 tables in Fox Pro to see if I had any better luck... and I didn't. Saved Excel files as .CSV and imported them into Fox Pro 9. I have added a field, call it ABC, in each table and populated the ABC field in both tables...
  18. Vatchunter

    VLOOKUP Issues

    I understand that... BUT they should be the same, it's either a space(s) or data type mismatch that is keeping these records from getting a valid match. Need to figure out how to get the data on both work sheets consistent.
  19. Vatchunter

    VLOOKUP Issues

    It does not find the info either....
  20. Vatchunter

    VLOOKUP Issues

    I'm talking about the 5 separate fields that make up the one lookup field.

Part and Inventory Search

Back
Top