I IanT Registered User. Local time Today, 19:46 Joined Nov 30, 2001 Messages 191 Jan 27, 2009 #1 I have a string that looks like $D$42. I need to identify the data after the second $ i.e 42. Can anyone advise.. Thanks in advance
I have a string that looks like $D$42. I need to identify the data after the second $ i.e 42. Can anyone advise.. Thanks in advance
N namliam The Mailman - AWF VIP Local time Today, 20:46 Joined Aug 11, 2003 Messages 11,685 Jan 27, 2009 #2 Look up the InstrRev function as well as the Right and Mod functions in the access help. See if you can figure it out from there, if not ask me/us here. Good luck
Look up the InstrRev function as well as the Right and Mod functions in the access help. See if you can figure it out from there, if not ask me/us here. Good luck
A Atomic Shrimp Humanoid lifeform Local time Today, 19:46 Joined Jun 16, 2000 Messages 1,953 Jan 27, 2009 #3 How variable in length, if at all, are the bits other than the $ characters? Do you ever have strings that look like: $DFGHTY$42 A$D$42 ?
How variable in length, if at all, are the bits other than the $ characters? Do you ever have strings that look like: $DFGHTY$42 A$D$42 ?
