Search results for query: *

I need a way to convert an ASCII character (the % sign) to it's corresponding octal value (045) on the unix platform. I have attempted to do this conversion using the following unix commands, and I haven't had any success. sed, tr. Here is a sample of the data file: (octal dump)...

I am trying to update/insert a new record into a sub-form based on new information from the main form. Each change needs to create a new row in the subform section of the form. here is the code for my refresh button that should insert the record. Private Sub cmdRefresh_Click()...

I am needing help getting started on what should be a simple project. I need to read one xml file, validate some of the data then write the same file plus an inserted status line out to another xml file… simple right? Well, bear in mind that I have not used xml files before and have only...

Thanks for the responses.... I got it figured out just after posting, but lost connection... Thanks again..

I have this code to parse through a text file. The parsing works great, but I have one minor problem.... some of the fields may start with zeros, and the output is dropping them.... how do I get the output to print exactly what is in the input file???? Thanks in advance for your help...

Disregard my last message. Got it working. Thanks again.

Thanks fredericofonseca! I tried your solution of adding the Mid, there is only one problem. The first field that is seperated by the comma is correct, but any additional have the first 2 characters from the first printed with it. ie: rm ##98S 1234 rm ##98S 123456 rm ##98S...

Hello All, I am needing help getting an output file in the correct format. My input file(.txt) has 3 fields. The fields are delimited by tabs, but the 3rd field has ranges and numbers seperated by commas. ie. (very small sample) rm ##98S 1234,3456,5678 rm ##233 345-678,679 I...

Simple problem, but I just can't seem to get it right. I have some data that I am inputting into a table set up as a text field. Some of the data is numeric however and whenever input into the tables the first 0 if there is one is dropped. How do I format this to keep the first 0 or multiple...

I figured it out. Thanks again for all your trouble...

By spit it out I mean Print it like it is..... if readline(0) or readline(1) not numeric then print #2, readline(0);"";"*" print #2, readline(1);"";"*" End if I am just missing how to validate that readline(0) or readline(1) are not numeric. Andrea

I know this may be pesky but.... How do I spit out any fields that start with a alpha character instead of a number? Andrea[smile]

I am still not getting the 0 to appear in front of certain numbers. I didn't mention before, but there could be multiple 0's as well. Here is part of the code, can you show exactly where to format to keep the whole string? Do While Not EOF(1) ReDim Preserve Test(1, i) Line Input #1...

Figured out the error. I am getting output, but where the fields that begin with zero are losing that first character in the output. ie. 0200 0999 is translating to 200 201 202 etc.... How can I get it to keep the input field "intact"? Thanks again, Poltergeist. Here is...

Thanks for the help Poltergeist. I have added your code and am getting the following error. Run-time error '9' Subscript out of range. I added this: For i = readline(0) to readline(1) Print #2, readline(i) Next the debugger is highlighting the Print statement. i does = 200 (this...

Clarity, I hope follows: I have a VERY large tab delimited file. I have stripped out all the garbage and kept the 2 fields that I need. Lets call them LOW, and HIGH. ( I cheated and did this by importing into a db and did my cleaning there.)But need the final input and output files to be...

I have a tab delimited file that I am reading that now looks like this( I have managed to strip out all the rubbish): 0230 0233 544 546 0001 0050 A367 0865 I am stuck on how to compare field1 against field2. If field2 is larger than Field1 I need to print field1 through field2...

strongm, you are a vb GOD!!!!!!!!! You ROCK, as my kids would say!!! Thank you so much! Where can I get some good info on processing delimited files?? Looks like I am going to be doing a lot of it, and I was just getting comfortable with sql server200 db's. Oh well.. Thanks again...

strongm, Tried your solution and it does output to the file in the correct format, but again there are many blank lines as stated in previous posts. Know what is causing the problem now just looking for the solution. (like always) Thanks for you input. I really appreciate it. I will...

MichaelRed, I copied your code into a new Project, adjusted for file locations and am receiving the following : Run-Time Error 6. Overflow debugger highlights this line: Open Filout For Binary As #lgFilOut Len = Len(strOut) the Len(strOut) = 81446 Thanks for your help Andrea