topic Re: Split a string by second character in Application Development and Automation Discussions

Split a string by second character

former_member628493 — Tue, 20 Aug 2019 10:56:32 GMT

Hey guys,

first of all forgive my English, but I need your help with this.

I need to split a string by the second repetition of an hyphen, I know, I explain myself badly, but I give an example:

my string is like this:

CO-CODA (CODE) TA - 8 hours (500)

and I need it to be like this:

CO-CODA (CODE) TA

8 hours (500)

thanks

Sandra_Rossi — Tue, 20 Aug 2019 11:06:14 GMT

You can do it in many ways, for example with SPLIT, segment, substring_before, match, and so on.

former_member628493 — Tue, 20 Aug 2019 11:27:07 GMT

and if I don't know how many hyphens are in the string, how can I separate them in a way to have all the string until the last hyphen?

RaymondGiuseppi — Tue, 20 Aug 2019 11:40:18 GMT

Just read the online (or F1) help on statement SPLIT.

Sandra_Rossi — Tue, 20 Aug 2019 11:59:39 GMT

You can still do it with the statements above.

kaleem_ahmed — Tue, 20 Aug 2019 16:01:28 GMT

As mentioned by Sandra you can do it by many ways. Here is how you will do it by Split keyword.

First split the string into three strings at the hyphen. (Str1, Str2, Str3)

Then concatenate the first two part (Str1, Str2) into result string separated by hyphen.

DATA text TYPE string.

text = `CO-CODA (CODE) TA - 8 hours (500)`. "Example Text

SPLIT text AT '-' INTO: DATA(str1) DATA(str2) DATA(str3).

CONCATENATE str1 str2 INTO DATA(result) SEPARATED BY '-'.

WRITE:/ result.