Search results

I had a eureka moment. Rather obvious one actually. I realised that all my strings are a fixed length, bar one combination. I just dragged it all into excel, saved, and imported into access with a fixed delimiation (first row set as containing headers). Exported back to excel, transposed...

When I get home tonight (will be late) I'll thow a few things together and present what I have. It may all make a little more sense then.

Yes, good theory, however the issue is that I'm dealing with morse. I need to split the more characters up before I can determine the end of each segment. The above breakdown of the data encoding system, is based on the converted morse. Currently my data is just a garble of .._...._._..._

Lol, Don't get too lost in the complexities of the data it'self. Long story short, the data is predictable, and organised so that a group of 3 characters can seperate out what I need to do. It's old data that just needs to be sorted. So far I have not had much success with the above code...

Ok, to elaborate further, If I were to translate a string it would read: (I had wanted to keep this a little secret, but i'll be changing the system entirely due to my current problem) D00007iS00008iU00009i While there are more complex variations this would mean: Detection type 1 (motion), I...

Ok to clarify a little further, the morse came from machine generated transmissions. these were remote sensing units that reported a set string of 45 characters each session. The units used 3 letters (D, S and U) to declare detection type (D) state (S) and unit (U). these are all 3 letter...

Ok, a few questions to answer here. I have a large collection of text files generated by a radio translation program. The choice of 3 characters is an arbitrary choice as international morse varies in length. I do however need to analyze the data I have. There are NO spaces between each morse...

Thats gracefully simple, and I will try that. Loops are not my strong point, but no time like the present to lean. Will post again with the results. TY muchly.

Hi all, Working on a morse code translation function for a database in access 07 I'm having a little trouble working out how to acheive the next step. I need to be able to take the first 3 characters (from a string of morse) from a text box, send them to a variable for use in a code, and...