Hi everyone,

I am trying to build default passwords using my information in InfoAssist. FOr example, I am hoping to use someone's last name and birthday to get "Jones12121985".

Does anyone know how I could combine fields like that in InfoAssist?

Hi Ian - try this: LastName||Birthday

You can also use | which is a weak concatenation. It keeps trailing blanks.

Thanks for the quick reply! Its very helpful. Sadly, it did not work. I tried putting it in using the Compute function. Do I need to use this in a different function?

@Ian

I think the problem is that LastName is a string and Birthday is something else... Could be a integer or even a real date format.

You need to convert that to a String before you can concatenate it to LastName.

Look up format conversion functions like EDIT FPRINT or CVTDATE.

G'luck
Dave

Did you try using it in a DEFINE function? Compute is usually only used for aggregations.

T

Not to make matters more complicated, but are you aware of how I could take the last four digits of a value (i.e. social security number) and use it in that same format?

Sorry. The joy of password defaults is that I have to make them complicated.

Ian,

please check the help for functions.

You could use mod 10000 which will give you ( mathematically ) the last 4 digits.

you could also use EDIT etc.

quote:

Not to make matters more complicated, but are you aware of how I could take the last four digits of a value (i.e. social security number) and use it in that same format?

Like Dave said, the EDIT function looks to be the answer to your problems. Check out the two links below, they discuss using EDIT for format conversion as well as for adding/extracting characters in a string.
Converting
Extract/Add