Recent content by awelch

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