Split Data

[#1]

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?

[Sokkorn]

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