output file with pipe delimited and CRLF

[ABCDA]

Is there way to output a file as pipe delimited and also have CRLF added to the line?  Thanks!

[OTrieger · Accepted solution]

Hi @ABCDA 
You can, what you will need to do is to concatenate the data and set pipe as the delimiter and save the file as csv.

[ABCDA]

Thanks, anyway you could post an example?  I know how to concatenate the data and set the delimiter... But not sure how all that is put together.  Thanks again for you help!   - Got it... Concatenate each field with the delimiter and choose \n as the delimiter in the export...  Example:  [Field1]+"|"+[Field2]+"|"+[Field3]

Then on the output tool delimiters section:  Delimiters: \n