I was playing with Unique and did a concat , selecting \n hoping it would be interpreted as new line in excel, moderncsv or numbers but it simply shows as \n , I tried \r, no luck , tried \n no luck .
Opened BBEDIT, enable invisibles , Did a line break in BBEDIT (basically pressed enter key see screenshot line 3 till 6) , copied this and pasted in EDT as concat delimiter , it shows as space but does the trick
This will be a good addition to the right click menu.
But issue is we don’t edit data directly within the transform, it could only be allowed either in the start or at the end transform before output to file, otherwise any change in the middle will be hard to track as any number of transform could change the data within the middle transformation.
It would be interesting to see, how you are going to implement it.
You wouldn’t be able to edit the data table directly. It would just be an easier way to insert control characters into text fields for transforms. E.g. there would be an extra Insert control character item in this right click menu for the Delimiter field. This would easier than having to copy and paste in control character and less complex than using \ (or similar) to add control characters. For example if you wanted to use line feed or tab as your delimiter value.