Select a particular number from a field with a calculation..

[Koonce]

I am trying to setup a calculation to select a number or letter from a field.  Like Social Security number.  I have that field and put in the social security.   But for a form i want each number to go in a field so i can use on a form.  If i use left(ssnumber, 1) i am good it is the rest that is tricky. is there any help out there and thanks in advance,  I tried the middle function but that i did that wrong.

Edited Sunday at 11:10 PM by Koonce

[comment]

52 minutes ago, Koonce said:

I tried the middle function but that i did that wrong.

The Middle() function is the right approach here:

Middle ( SSN ; 4 ; 1 )

will return the 4th character in the SSN field.

 

52 minutes ago, Koonce said:

i want each number to go in a field

Instead of defining a separate field for each character you can use a single repeating calculation field =

Middle ( Extend ( SSN ) ; Get ( CalculationRepetitionNumber ) ; 1 )

 

Edited Monday at 12:01 AM by comment

[Koonce]

that worked perfectly and if there is no number it will give a 1 just asking

the reason i used a field is the form i was putting it on had different spacing

 

[comment]

2 minutes ago, Koonce said:

if there is no number it will give a 1 just asking

Sorry, I am not sure what you're saying here. If there is no character at the specified position the result will be an empty string.

 

[Koonce]

in the calc Middle( SSnumber ; 1 ; 1) i assumed the first number was the position the second number was returning a 1 if there was nothing in the position spot.

 

[comment]

No, the last parameter is the number of characters to return:
https://help.claris.com/en/pro-help/content/middle.html

 

Edited Monday at 12:49 AM by comment

[Koonce]

ok thank you for the help

[comment]

No problem.

BTW, any discussion concerning storing SSNs should mention this warning:
https://www.ssa.gov/phila/ProtectingSSNs.htm