Table Transformer - How to split by new line or break line?

Roberta Bortolotti February 3, 2025

Hi, I have a table column that has multiple values displayed like the following:

  • Brand
  • Data
  • Products

How do I split the text so that I have Brand, Data, and Products in separate rows using Table Transformer? I found an example but the delimiter is ",". In my case, the delimiter is the line break.

Here is what I found: https://docs.stiltsoft.com/tfac/dc-server/splitting-cell-values-to-different-rows-flatten-an-array-188621459.html

Any help would be appreciated.

Thank you.

1 answer

1 vote
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 3, 2025
Roberta Bortolotti February 3, 2025

Thank you, @Stiltsoft support 

I tried adding 3 spaces at the end of each option to see if I could split this way -- no luck.

Is it possible to use a combination of FORMATWIKI with the split function? Just brainstorming out loud.

 

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 3, 2025

The FORMATWIKI function is used to format the contents of your cells (make the text bold, color the background, and so on).

The SPLIT function works with strings and splits them by visible symbols, for example, commas, points, spaces (not bullets and new lines).

So, if you manually add a space after each word, the string will be splitted.

Roberta Bortolotti February 3, 2025

Thank you, @Stiltsoft support 

The split with spaces didn't work. Not sure why though. Any thoughts?

Also, can I combine MATCH_REGEXP with SPLIT?

Thank you again.

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 3, 2025

And have you adjusted the initial SQL query from the example accordingly?

SEARCH / AS @a EX('Skills'->split(" ")) /
RETURN(@a->'Name' AS 'Name', _ AS 'Skills') FROM T1

Also you may find the list of the supported functions and more examples in our documentation.

Roberta Bortolotti February 3, 2025

Not sure why, but it didn't work. I have 3 spaces in the split function. The 'New are concern' column shows empty.

Here is my statement:

SEARCH / AS @a EX('Key Area of Concern'->split("   ")) /
RETURN(@a->'New area concern' AS 'New area concern', _ AS 'Key Area of Concern') FROM T1

Any thoughts?

Thank you,

Roberta

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 3, 2025

Leave only one space in the split(" ") function, not two, three or more.

Roberta Bortolotti February 3, 2025

In this case I can't have a bullet point with an option that is a composed term. For example, "New Products". 

Are you saying it cannot split based on multiple spaces?

Thank you

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 3, 2025

Yes, you are correct. You may use an underscore for strings with several words though: New_Products.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events