on 04-01-2015 9:55 AM
Hi all,
I have to implement the following logic in an HANA calculation view preferably in Graphical calculation view.
I have a field like BKTXT which contains either number or text or both and datatype of the field is VARCHAR.
Requirement is to create a calculated column:
How can I implement this logic?
Here was the algorithm I thought of though unable to implement so far:
I am facing challenge to identify a numeric field in character field. If I can do that also how to run a loop here to take our a 3 digit or more number from the text field
Thanks in advance.
Why Loop ?
Use select case for part of it, andcombine with regex
IF You have sps09 you cyn use regex...something like
select substring_regexpr( '(\d+)' IN 'r375' ) "broj" from DUMMY;
of course you'll have IN BKTXT ...and from is some complex or not so complex join.
SUBSTRING_REGEXPR - SAP HANA SQL and System Views Reference - SAP Library
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.