By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 981 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

Acc2K - Parse Memo Field into Separate Fields

MindBender77
100+
P: 234
Hello Again All,

I have a memo field that is backslash delimited. I am attempting to break up this field into individual fields.

Ex (memo field). \John L. Doe\\StreetName RD\\City, Pa 11111
Expand|Select|Wrap|Line Numbers
  1. To look like this:
  2. John L. Doe          StreetName RD         City, Pa 11111
  3.  
I have been using this function in a query which, works fine if that part in the memo field is always constant i.e. company name.
Expand|Select|Wrap|Line Numbers
  1. right(left[tablename],instr(x, [tablename],"\")-1,x)   'where x is an integer
  2.  
How can I parse, say the customer name, being that it's never a constant length?

Bender
Aug 22 '08 #1
Share this Question
Share on Google+
1 Reply


FishVal
Expert 2.5K+
P: 2,653
Hi, Bender.

You may use Split() function to parse substrings easily.

Regards,
Fish
Aug 22 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.