Parse data of varying lengths in MS Access
Posted on 2011-03-03
I need help in parsing data from one field into multiple fields. I've tried different mid/len/first/last statements and none have worked.
Example of the data in the field:
The data can be any length -- one character or a hundred characters -- No change is needed for the fields that are less than 100 characters
The fields that have characters over 100 I need to parse them into separate fields so that I can join the fields for other analysis and MS Access
will not let you join fields over 255 characters which is the reason I need to break it up.
I'm tracking how many users click a link but I can't compare usage on any one link because of the inability to join the fields that are over 255 but if I could parse the data
I could get the other logic to work.