Text File Generation

Ravi Roshan over 7 years ago

I am creating a text file with the multiple pipe delimiter data. When the file is created it is not storing the data one by one like -
ABC|DEF||GJI
123|435|235

I am getting the output like - ABC|DEF||GJI 123|435|235
However when I open the same file with NPP, Excel or CSV format is it displaying properly.

Discussion posts and replies are publicly visible

0 Colton Beck over 7 years ago

Are you expecting the line breaks to display in Windows Notepad, or are you using some other text editor?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 erick258 over 7 years ago

Have you tried adding "chr(13)&chr(10)" to break between lines e.g. "ABC|DEF|GJI"&chr(13)&chr(10)&"123|435|235"
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ravi Roshan over 7 years ago

@coltonb, Yes I want to display in Windows Notepad. In other editor like notepad++ it is displaying correctly.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ravi Roshan over 7 years ago

@erick258, Yes I am using char(10)&char(13), that is why it is appearing correctly in other editors.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Colton Beck over 7 years ago

Notepad behaves differently from other text editors like NPP, Sublime, etc with respect to line breaks. I recommend doing some research. This has some good information:
superuser.com/.../notepad-ignoring-linebreaks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ravi Roshan over 7 years ago

@coltonb, Thank you... let me check if I can get some help :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Soujanya B over 4 years ago

Hi,

I have the same use case to generate text file in Appian.

Let me know how you generated the file.

Thanks

Soujanya
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel