What's new?

We've introduced new text manipulation operations in the Data Set Manager, giving you the power to clean and transform your data, making it ready for use in Abacum.

These are the newly added operations:

• MID: Same as its Excel equivalent. It extracts a substring by position indexes. 
• SUBSTITUTE: Looks for the appearance of certain fragments in a text and replaces all occurrences with the desired value. Works in the same way as Substitute in Excel. 
• TEXTSPLIT: Splits text strings by a given delimiter across columns. Then, from the generated splits, it keeps the desired one. 
• TRIM: Removes all spaces from text except for single spaces between words. 

To dive deeper into syntax and the use of operators, check out our academy article.