Sl. No. | Field Name | | Result | Description | |
| | Name | 1 | 2 | |
| | | | | |
1 | Applicant ID | George Kriss | G K | | Only the first letter of First Name and Last Name from C4 must be displayed in Column D4 in Upper Case, with 5 spaces in b/w |
| | george kriss | G K | | " |
| | GEORGE KRISS | G K | | " |
| | GEORGE KRISS JR | G K | | " |
| | GEORGE KRISS, JR | G K | JR | If Name is followed by a 'Coma' [,] along with 'JR' in any case. Above criteria as in F4 + JR in column E8 respectively |
| | | | | |
| | | | | |
2 | Applicant Name | CurtisBlair | Curtis Blair | | However style the Name appears in Column C , corresponding D coulmn Should return Full Name as in D11 with 1 space in b/w |
| | Curtis Blair | Curtis Blair | | " |
| | CURTIS BLAIR | Curtis Blair | | " |
| | Curtis Blair | Curtis Blair | | " |
| | | | | |
3 | Co-Applicant Name | Lisa Blair | Lisa Blair | | If anything displayed on C16, result Full Name at D16 (format at D16) |
| | | N/A | | If nothing is displayed on B16, then C16 should display N/A in Upper Case |
| | | | | |
4 | Applicant - First Name | George Kriss | George | | The result in D19 displays only the First Name with First Letter Caps from C19 |
| | | | | |
5 | Middle Name | Curtis Blair | B | | D21 should display Second Names First letter from C21 in Caps "B" |
| | | | | |
6 | Address | 125 North Suite, 5th Street | 125 NORTH SUITE,… | | D23 should display everything in CAPS from C23 |
| | | | | |
7 | City | New York | new york | | D25 displays everything in Lower case from C25 |
| | | | | |
8 | Phone | 9037015967 | 90 370 159 69 | | D27 returns content of C27 in specified format |
| | | | | |
9 | Purchase price | $156,000 | $156,000.00 | | D29 returns content of C29 in specified format |
| | | | | |
10 | Cashout Amount | 10,000.00 | 10000 | | Result provides no decimals and no coma (,) seperators in column D31 form column C31 |
| | 10,000 | 10000 | | Result provides no decimals and no coma (,) seperators in column D32 form column C32 |
| | | | | |
11 | Years with Employer | 2.3 | 2.3 | | D34 displays result from C34 with 1 decimal point |
| | | | | |
12 | Income | 25,000 | 25000 | | No decimals ; no coma (,) seperators |
| | 25000 | 25000 | | No decimals ; no coma (,) seperators |
| | | | | |
13 | Score | 670 | 670 | | Only three digit Numbers |
| | | | | |
14 | Call back time | 18:00 | 18:00 | | Military time |
| | | | | |
15 | Call back date | 7/20/2004 | 7/22/2004 | | D43 contains date, three days from the day the form C43 (i.e. from 20,21,22) |
| | | | | |
16 | Call back phone | 90 370 159 67 | 9037015967 | | Whichever format the number appears, D45 returns numbers without spaces |
| | 9037015967 | 9037015967 | | Whichever format the number appears, D45 returns numbers without spaces |
| | | | | |
17 | First Name Ini | GEORGE | G | | Display the First Letter of C48 in D48 in CAPS |
<colgroup><col style="mso-width-source:userset;mso-width-alt:2669;width:55pt" width="73"> <col style="mso-width-source:userset;mso-width-alt:5339;width:110pt" width="146"> <col style="mso-width-source:userset;mso-width-alt:6326;width:130pt" width="173"> <col style="mso-width-source:userset;mso-width-alt:4681;width:96pt" width="128"> <col style="mso-width-source:userset;mso-width-alt:1828;width:38pt" width="50"> <col style="mso-width-source:userset;mso-width-alt:28123;width:577pt" width="769"> </colgroup><tbody>