I was able to get it working already getting the first argument through SELECT Left ([Data], InStr(1,[Data],Chr(44))) FROM Export.
How do I get the every argument? Next argument is the number. The next one is after the "--". Then the next one is after every comma. Please help. Thanks. L y a n n e R h e e z a C. O n g ----- Original Message ---- From: Lyanne Rheeza Ong <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, July 8, 2008 11:08:12 AM Subject: [ms_access] Function to get the first argument proceeded by a comma Hello, How do I get the first argument Root User Class from a table in the field. What function should I use? The first argument changes, but the first argument is always proceeded with a comma. "Root User Class","45272 - -Amit, Padgilwar, [EMAIL PROTECTED] com, bas\45272" Please help. Thanks. L y a n n e R h e e z a C. O n g [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
