Hellos,
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
Thanks. As you say you can paste in a control character, but you can’t type it in using \ to ‘escape’ the control characters.
Using \ to escape control characters (e.g. ‘\n’ for linefeed and ‘\n’ to mean ‘\n’) is a rather ‘techie’ approach that might be confusing to some people.
Note also that you can press the ‘eye’ button to see whitespace characters.
Having an extra Insert control character item with options such as line feed, carriage return, tab etc, in the right click menu for text fields might be useful.
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.