aarondewberry
IS-IT--Management
All
I have a field called Postal Code. This field is eight characters long regardless of the number of characters in the outcode, there will just be more spaces in the middle. For example E6 3NP will have 3 spaces while SW16 1NH will have just the one. I am trying to link this to a personal data file by postcode (one space between regardless) and of course there is no matches.
I had initially created a variable to cut, trim and concatenate the postcode into a format that would match only to find that you are unable to link to tables via a created variable object.
Next stop was a User Object, and to my dismay I discovered that the functions for a User Object is far less user friendly than creating a variable. Subsequently I am having trouble nesting functions to replicate my initial logic.
Thought I had cracked it with a concatenate of:-
A righttrim of a subtring of the postal code that would start at character1 and will be 4 characters long.
Then a further substring of the postal code starting at character 5 and taking 4 characters (inclusive of one space).
Nightmare, it seems right trim syntax expects different parameters if you are creating a user object as opposed to a variable. Using a right trim in a variable, you are asked only to select an object to trim where as a user object will ask that you select an object and a character (whatever that means).
Obviously any assistance will be greatly appreciated.
I have a field called Postal Code. This field is eight characters long regardless of the number of characters in the outcode, there will just be more spaces in the middle. For example E6 3NP will have 3 spaces while SW16 1NH will have just the one. I am trying to link this to a personal data file by postcode (one space between regardless) and of course there is no matches.
I had initially created a variable to cut, trim and concatenate the postcode into a format that would match only to find that you are unable to link to tables via a created variable object.
Next stop was a User Object, and to my dismay I discovered that the functions for a User Object is far less user friendly than creating a variable. Subsequently I am having trouble nesting functions to replicate my initial logic.
Thought I had cracked it with a concatenate of:-
A righttrim of a subtring of the postal code that would start at character1 and will be 4 characters long.
Then a further substring of the postal code starting at character 5 and taking 4 characters (inclusive of one space).
Nightmare, it seems right trim syntax expects different parameters if you are creating a user object as opposed to a variable. Using a right trim in a variable, you are asked only to select an object to trim where as a user object will ask that you select an object and a character (whatever that means).
Obviously any assistance will be greatly appreciated.