Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
NEED help for following:-
PFA image
My data is in alphanumeric format as shown in attached image below i need to extract only numeric part :-
Please help
but how cani specify second part data is different in all rows
Use KeepChar(FieldName) as Field_Name
This should work
Regards
Chaitanya
use purgechar(Fieldname) as String_Data
and
use keepchar(Fieldname) as Numeric_Data
so you will get the values in 2 different fields
Try this
KeepChar(SAP_CODE,'0123456789') as SAP_CODE
Regards
ASHFAQ
yup it worked,,Thanx
Hi,
Can you close this thread by selecting appropriate answers.
Regards
ASHFAQ
Hii Snehal,
Use the following script to keep only numeric data:-
LOAD * INLINE [
A
12s
234f
];
store S into S.qvd;
drop Table S;
d:
LOAD PurgeChar(A,'sf') as A
FROM
S.qvd
(qvd);
Thanks & Regards
Prince Anand
load
....,
KeepChar(yourfield , '0123456789') as newfield
.....
from
.....