on 07-20-2015 7:58 AM
Hi,
I want to split a string like below
OTHER!@!1000-01-01!@!N!@!TEST EXPLANATION' -- KEYWORD!@!ACCOUNT!@!MANSYS!@!EXCLUDEEXPLANATION
I want to split the string where it has !@! using regular expression.
Please help me.
Hi,
You do not need regex for this.
Refer this StackOverflow page, they've addressed the same issue: http://stackoverflow.com/questions/27709088/hana-split-string
In that page they've used comma "," as the delimiter, you can use "!@!" instead.
By the way, if you are getting this data from elsewhere, like from a Java program or Python script etc, think about doing the splits there. Most languages have some sort of String.split() function that will be easier than creating a procedure in HANA.
Regards,
Suhas
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 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.