# Combined Text Summary Field (Order and Clean)

• 0
• Question
• Updated 2 months ago
The Combine Text summary field is great. But what I would like to do is determine the order -- Which I have achieved by creating a [Order] field within my child table....

[Combine Text Field] = 1 Group A, 2 GroupD, 3 GroupH, 4 GroupY, 5 GroupU, 6 GroupK

The new Ordered Combine Text Field is now ordered -- but I want to remove the numbers as well as ";" which is "hidden" in the combine text field.

Example: when I create a rich text formula field -- and only insert the [Combine Text Field] -- the field is displayed -- [Rich Text Formula fieldA] = 1 Group A, ; 2 GroupD, ; 3 GroupH, ; 4 GroupY, ; 5 GroupU, ; 6 GroupK

I would like for the field to display as =  Group A, GroupD, GroupH, GroupY, GroupU, GroupK

I was almost successful with the formula below -- but the formula would only display the first five Groups --- so if greater than 6 groups --- no luck -- also issue is I had "10" as a position...

Almost worked formula below = Group A, GroupD, GroupH, GroupY, GroupU,

List ("",
Part(ToText([Combined Text]),1,"123456789;"),
Part(ToText([Combined Text]),2,"123456789;"),
Part(ToText([Combined Text]),3,"123456789;"),
Part(ToText([Combined Text]),4,"123456789;"),
Part(ToText([Combined Text]),5,"123456789;"),
Part(ToText([Combined Text]),6,"123456789;"),
Part(ToText([Combined Text]),7,"123456789;"),
Part(ToText([Combined Text]),8,"123456789;"),
Part(ToText([Combined Text]),9,"123456789;"),
Part(ToText([Combined Text]),10,"123456789;"),
Part(ToText([Combined Text]),11,"123456789;"))

Any advice is greatly appreciated.
• 694 Points Posted 2 months ago

• 0

QuickBaseCoach App Dev./Training, Champion

• 62,438 Points var text value = ToText([my combined text summary field]);

List(", ",
Trim(Part(\$value,1,";")),
Trim(Part(\$value,2,";")),
Trim(Part(\$value,3,";")),
Trim(Part(\$value,4,";")),
Trim(Part(\$value,5,";")),
Trim(Part(\$value,6,";")),
Trim(Part(\$value,7,";")),
Trim(Part(\$value,8,";")),
Trim(Part(\$value,9,";")),
Trim(Part(\$value,10,";")),
Trim(Part(\$value,11,";")),
Trim(Part(\$value,12,";")),
Trim(Part(\$value,13,";")),
Trim(Part(\$value,14,";")),
Trim(Part(\$value,15,";")),
Trim(Part(\$value,16,";")),
Trim(Part(\$value,17,";")),
Trim(Part(\$value,18,";")),
Trim(Part(\$value,19,";")),
Trim(Part(\$value,20,";")),
Trim(Part(\$value,21,";")),
Trim(Part(\$value,22,";")),
Trim(Part(\$value,23,";")),
Trim(Part(\$value,24,";")),
Trim(Part(\$value,25,";"))
)
• 694 Points Mark,

Your formula works great for removing the ";" --- any suggestions for removing the numbers --

1 Group A, ; 2 GroupD, ; 3 GroupH, ; 4 GroupY, ; 5 GroupU, ; 6 GroupK

I use the numbers to allow me to determine the order ---

Thank you

QuickBaseCoach App Dev./Training, Champion

• 62,438 Points List(", ",
Trim(NotLeft(Part(\$value,1,";"),2)),
Trim(NotLeft(Part(\$value,2,";")),2),

etc

• 694 Points Thank you Mark.....worked great!