Search results for query: *

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

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

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

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,

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

subscribe

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

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

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

Thanks Mike! worked perfect!

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!

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

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

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)...

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

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

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

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.

It does not find the info either....

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