Hi all,
I am leveraging the concatenate column manipulation method in GQI query. I want to concatenate the columns with newline.
I want the value in the new column (COPY DATA) to be like this
sdt_CH25
Main: srt://127.0.0.1:3700|Pull
AES passphrase: xxxxx
Instead of
sdt_CH25 Main: srt://127.0.0.1:3700|Pull AES passphrase: xxxxx
I tried to use the \n as the separator but it displays the \n as it is instead of interpreting it as the newline separator.
How can I achieve this?
Hi Fenta,
Unfortunately, this isn’t possible using the built-in concatenate operator. The single-line textbox does not allow newline characters, and escape characters don’t appear to be supported either.
However, you could easily create a custom operator to concatenate the two columns and insert a newline between them.