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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Vatchunter

  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

    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...
  7. 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...
  8. 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
  9. Vatchunter

    Inserting the Date into a Character String

    Thanks Mike! worked perfect!
  10. 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!
  11. 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!
  12. 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?
  13. 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)...
  14. 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...

Part and Inventory Search

Back
Top