Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please help me,
In Put data:
LOAD * INLINE [
ID, Set Name
1, PMP_1.2.1.2_Developer Solutions.
2, 2.5.6.21_Research
3, Methodology implementations_5.17.8.6
4, P_2.11.4.5
5, 3.3.3.11_Methods
6, ST_1.2.1_conform
7, Views_2.1_Values
8, 2.4.5.2_Key Points & Key Values.
];
I have two fields ID and set Name,
Required out Put:
ID Set Name Set value
1 PMP_1.2.1.2_Developer Solutions. 1.2.1.2
2 2.5.6.21_Research 2.5.6.21
3 Methodology implementations_5.17.8.6 5.17.8.6
4 P_2.11.4.5 2.11.4.5
5 3.3.3.11_Methods 3.3.3.11
6 ST_1.2.1_conform 1.2.1
7 Views_2.1_Values 2.1
8 2.4.5.2_Key Points & Key Values. 2.4.5.2
I want to get only Number form the set Name field above format.
Please Help me , Thanks.
One solution is.
tab1:
LOAD *
Where Flag;
LOAD *, FindOneOf([Set Value],'1234567890') As Flag
;
LOAD *, SubField([Set Name],'_') As [Set Value]
;
LOAD * INLINE [
ID, Set Name
1, PMP_1.2.1.2_Developer Solutions.
2, 2.5.6.21_Research
3, Methodology implementations_5.17.8.6
4, P_2.11.4.5
5, 3.3.3.11_Methods
6, ST_1.2.1_conform
7, Views_2.1_Values
8, 2.4.5.2_Key Points & Key Values.
];
One solution is.
tab1:
LOAD *
Where Flag;
LOAD *, FindOneOf([Set Value],'1234567890') As Flag
;
LOAD *, SubField([Set Name],'_') As [Set Value]
;
LOAD * INLINE [
ID, Set Name
1, PMP_1.2.1.2_Developer Solutions.
2, 2.5.6.21_Research
3, Methodology implementations_5.17.8.6
4, P_2.11.4.5
5, 3.3.3.11_Methods
6, ST_1.2.1_conform
7, Views_2.1_Values
8, 2.4.5.2_Key Points & Key Values.
];
Hi Saran,
Thank You.
you welcome