I need to ascending value from variable

input
str=“aaa<>ccc<>ddd<>bbb<>eee”

output str=“aaa<>bbb<>ccc<>ddd<>eee”

i need to change to ascending order

Hi @Jijendiran_Murugan

Assign str = "aaa<>ccc<>ddd<>bbb<>eee"

Assign strArray = str.Split({"<>"}, StringSplitOptions.None)
Assign sortedArray = strArray.Skip(1).Take(strArray.Length - 2).OrderBy(Function(s) s).ToArray()

Assign sortedStr = strArray(0) + "<>" + String.Join("<>", sortedArray) + "<>" + strArray(strArray.Length - 1)

Regards

1 Like

Hi @Jijendiran_Murugan

- Assign -> str = "aaa<>ccc<>ddd<>bbb<>eee"

- Assign -> strArray = str.Split({"<>"}, StringSplitOptions.None)

- Assign -> strArray = strArray.OrderBy(Function(s) s).ToArray()

- Assign -> str = String.Join("<>", strArray)

Check the below workflow for better understanding,

Hope it helps!!

2 Likes

Hi @Jijendiran_Murugan

Input="aaa<>ccc<>ddd<>bbb<>eee"
Output=String.Join("<>", Input.Split({"<>".ToCharArray}, StringSplitOptions.RemoveEmptyEntries).OrderBy(Function(s) s).ToArray())

Cheers!!

1 Like

Hi @Jijendiran_Murugan

Multi Assign activity:
   - Create a variable inputStr and assign the value: "aaa<>ccc<>ddd<>bbb<>eee"
   - Create a variable delimiter and assign the value: "<>"
   - Create a variable strArray of type String[] and assign the value: `inputStr.Split({delimiter}, StringSplitOptions.None)
   - Create a variable sortedArray of type String[] and assign the value: strArray.OrderBy(Function(x) x).ToArray()
   - Create a variable outputStr and assign the value: String.Join(delimiter, sortedArray)

1 Like

@Jijendiran_Murugan

assign: out_str=String.Join(“<>”, “aaa<>ccc<>ddd<>bbb<>eee”.Split({“<>”}, StringSplitOptions.RemoveEmptyEntries).OrderBy(Function(x) x).ToArray())

Cheers!!

1 Like

Hi @Jijendiran_Murugan

str=“aaa<>ccc<>ddd<>bbb<>eee”
StringArray=str.Split({“<>”}, StringSplitOptions.None)

Use Invoke Method

TargetType: System.Array
MethodName Sort
Parameters : Add an In/Out argument with stringArray

Write Line - sortedString = String.Join(“<>”, stringArray)

Hope this helps

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.