View Output Using Notepad ++

If you're wanting to open your output file with Notepad++, you could output it as a .txt instead of .csv. Then, when you go to the folder where it sits, it'll be in the file format that Notepad++ opens. Just set the Output Data tool to output as a CSV, but give it a file extension of .txt for your file path under "Write to File or Database."

Output to Text.PNG

Output to Text File.yxzp

Thanks for the response however, what I wanted is to produce an output in pdf format so that the appearance showing the CRLF will be seen automatically. I need to get the appearance of the result of the notepad ++ and convert it into pdf combined.

Can you help me on this?

Thank,

Kamen

@KamenRider You can input your Notepad++ file as a .csv. Your Input Data tool configuration might look different from mine as my data is tab delimited and yours looks comma delimited. I'm using a Table tool then a Render tool to output as a PDF. If you select "Choose a Specific Output File" instead of "Temporary PDF Document," it'll have you map to where you want the PDF to go. Let me know if that works.

Text File Input Config.PNG

Text to PDF.PNG

Thank for the response, however I would like my output to look like this.

Hoping we can find way to solve this. Looking forward for your response.

Thanks,

Kamen

@KamenRider Can you please post some sample data?

Here's a sample file attached in csv file. Have it read by notepad ++ and then the result from notepad ++ will be the output in pdf.

Hope we could make it.

Thanks,

Kamen

Sample.csv

@KamenRider Are the characters "CR" and "LF" supposed to be in the sample data? I don't see them in Alteryx or when I open the file using Notepad++.

Sample Data.PNG

You have to enable the CRLF in Notepad++. See below how.

*In Notepad++ go to the View > Show Symbol menu and select Show End of Line.

*Once you select View > Show Symbol > Show End of Line you can see the CR LF characters visually

Thanks,

Kamen

Felipe_Ribeir0

@KamenRider this one is challenging - and i wonder why you need it, never saw this requirement before - anyway, my best guess would be to use cmd/python to interact with notepad++ and print the file directly from it.

Tomorrow i will take a better look and see if this idea make sense.

caltang

Just to chip in, I tried to do something like this before but Notepad++ serves more as an extension of the Text files that help better read the content.

Hence, you may need something else to overcome this. https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/How-To-Use-the-Analyse-Plugin-in-Notepad-to-Review-Logs/ta-p/594493

Hope that helps!

@Felipe_Ribeir0

Thanks for giving time to this. Please be advised that my file is in csv format. Manually, we open it in Notepad++ and view the CRLF. My goal is to have the file viewed with CRLF with automatically open in Notepad ++ or better in pdf format.

Looking forward for your idea soluton.

Thanks,

Kamen

Hi @caltang

Thanks for your suggestion. I will look into this if this is applicable to my project. This kind of nice solution. I hope this can be connected to my Alteryx designer I am working.

Thanks,

Kamen