Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please anyone can help me to split data then check data:
Example: 2 y,3 m
3 y, 4 m
then how to check.
Data attached,please check?
Please help any one?
Hi,
Not sure this one you looking for
Code | Name | DOB | DOJ | GRADE | DESIGNATION | DEPARTMENT | LOCATION | M / F | Relv. Experience | F1 | F2 |
C010091 | Vinay Kumar Sharma | 20-Jul-74 | 12-Feb-97 | G4 | Assistant Manager Finance | FINANCE | NCR | M | 14 Y, 11 M | 14 Y | 11 M |
C010967 | Pradeep Kumar | 9-May-81 | 15-Nov-06 | G3 | Senior Accounts Executive | FINANCE | NCR | M | 6 Y, 7 M | 6 Y | 7 M |
C011162 | Devender Pal | 2-Jun-86 | 1-Jan-08 | G2 | Accounts Executive | FINANCE | NCR | M | 8 Y, 4 M | 8 Y | 4 M |
I added two field (F1 and F2). If this one is you looking for then try two ways to get this done:
1. Load
LOAD
SubField([Relv. Experience],',',1) AS [F1],
SubField([Relv. Experience],',',2) AS [F2],
2. Use expression
SubField([Relv. Experience],',',1)
SubField([Relv. Experience],',',2)
Regards,
Sokkorn