View Output Using Notepad ++

[KamenRider]

Hi guys,

I am not sure if this is possible but I would like to view my output using the notepad ++ either to convert into pdf. The raw file is csv and I would like this to view as like below: I need to check if it has CRLF at the end.

Please advise what tool I am going to use. Any ideas is very much appreciated.

Thanks,

Kamen

[Prometheus]

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."

[KamenRider]

Hi @Prometheus 

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

[Prometheus]

@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.

 

 

[KamenRider]

Hi @Prometheus 

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

[Prometheus]

@KamenRider Can you please post some sample data?

[KamenRider]

Hi @Prometheus 

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

[Prometheus]

@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++.

 

[KamenRider]

Hi @Prometheus 

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

[KamenRider]

Hi @Felipe_Ribeir0

I would like to seek you help if this is possible.

Please advise.

Kamen