Split based on New line character in Table Transformer

Question

Hi,

I am able to split based on ";"  in Table Transformer.

I am unable to split based on new line.  Please help. I tried "
", "
", "",  CHAR(10), CHAR(13).

SEARCH / AS @a EX('Dependencies'->split(";")) / RETURN(@a->'Architecture Service' AS 'Architecture Service', _ AS 'Dependencies') FROM T1

Stiltsoft support · Answer

Yes, you've got it right: the bullets and new lines are invisible html tags used for formatting, the strings can't be splitted by them.

Nivedita R · Answer

If it is a bullet list, or if the entries are in individual lines, will it not possible to split them?  Is using a visible character the only way?

Nivedita R · Answer

Table Filter, Charts & Spreadsheets for Confluence app.