32
Views
3
Comments
Solved
string_split
Question

hello there,

by using string split, need to check more delimiters like "+", "-" ,"*" ,"/" i.e(12+34-35/87) then I have value list as 12 , 34, 35, 87.

now I can do only one operator how to achieve for many...



Rank: #95
Solution

Hi Ansari,


You should put on the field "Pattern" the following:

\+|\*|\/

The \ is for escaping because +, * and / are special characters and | serves as an OR in Regex.


Cheers,

João

Rank: #95

Hi Ansari,


You can use Regex actions to normalize the delimiters (e.g. substitute the "+", "*" and "/" for "-"), and then use the string split on the output. So in your example you'd 12-34-35-87, ready to split by the "-".

This is the function you use to do do the replacement.


Cheers,

João

Rank: #95
Solution

Hi Ansari,


You should put on the field "Pattern" the following:

\+|\*|\/

The \ is for escaping because +, * and / are special characters and | serves as an OR in Regex.


Cheers,

João