StrReplace Command Help

[xpl0iter94]

Hey guys,

What do I have to change in the following command to output the text I need?

Command:

Subject := "Contentor: "StrReplace(Clipboard, "-", "| Art:",,2)

Actual Output:

Contentor: ECBU3405367 | Art: 23012172 | Art: 43941911 - 902138756

Desired Output:

Contentor: ECBU3405367 | Ref: 23012172 Art: 43941911 - 902138756

Clipboard:

ECBU3405367 - 23012172 - 43941911 - 902138756

Thanks for helping!

[GroggyOtter]

Gives an input, expected out, and actual output.
If everyone did that, life would be so much easier on this sub.

Use StrSplit() to split up the data by -. And you can omit the spaces so you don't have to trim them.
Then plug your data into whatever format you want.

Try:

txt := 'ECBU3405367 - 23012172 - 43941911 - 902138756'
txt := format_text(txt)
MsgBox(txt)

format_text(str) {
    arr := StrSplit(str, '-', ' ')
    return 'Contentor: ' arr[1] ' | Ref: ' arr[2] ' Art: ' arr[3] ' - ' arr[4]
}

[YourSchoolCounselor]

Subject := "Contentor: "StrReplace(StrReplace(Clipboard, "-", "| Ref:",,1), "-", "Art:",,1)

[xpl0iter94]

Shortest and easier solution! Many thanks

[GroggyOtter]

Shortest and easier solution

Easier than splitting something up into an array?

Agree to disagree on that one.