Acc2K - Parse Memo Field into Separate Fields

[MindBender77]

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

To look like this:
John L. Doe          StreetName RD         City, Pa 11111
 

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.

right(left[tablename],instr(x, [tablename],"\")-1,x)   'where x is an integer
 

How can I parse, say the customer name, being that it's never a constant length?

Bender

[FishVal]

Hi, Bender.

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

Regards,
Fish