Split "Mistake returns"

Support
1

Hi Dmitry

I have data from a bank. In the text I partially have the description with CH as the country and CHF as the Swiss franc one after the other. CH CHF
I would like to use the Split action to break the text into two columns. Once the description including the CH if it is there (see Description_1) or not (see Description_2)
Goal:
Description_1 CH
Description_2
I used four different split separators,
-CHF-

  • CHF-
    -CHF -
  • CHF -
    but in variants 1 and 3 I get a CHH after Description_1 and in variants 2 and 4 a CHCH

Why ?
How can I easily implement this?
Test Split.txt (91 Bytes)
Test Split Mistake.morph (9,6 KB)

Suggestion for improvement:
Could you make an extension so that parameters can also be selected.
I think the "Custom Seperator Editor" is very good, but a parameter variable is the easier or better choice!

2

Hi Reinhard,

It looks like "Split delimited text" doesn't work correctly with this specific custom separator and this particular text. We will investigate it.

Meanwhile, you can use text functions to parse the description as necessary. See the example below:

Test Split Mistake.morph (4.4 KB)

image
image1165×521 17.5 KB

3

Hi Dmitry
Thanks for the fast meantime solution.

Suggestion for improvement:
Could you make an extension so that parameters can also be selected.
I think the "Custom Seperator Editor" is very good, but a parameter variable is the easier or better choice sometime !

4

Added in Feature requests

5

We've fixed the bug. Please install the updated version from our website.

6

Thanks Dmitry
Question: You will ad in the future that the custom seperator also can get by parameter option?

7

We might, but no hard due date for that.

1 Like
8

Thanks
For me this topic solved

1 Like