Hello Everyone,
I am converting HTML to CSV using this process nodes and it's working fine. Although I can export data store entity to CSV- but there is different requirement, so I am not using this approach. Please see below screenshot.
Requirement: When I open that CSV file in Notepad++ I see this:
I need to remove these quotes in a file. How can I achieve this?Thanks
Discussion posts and replies are publicly visible
Can you go a bit more in depth into your use case / what you're hoping to accomplish?
To clarify, CSV files use quotes as a very important piece of their formatting; if you simply stripped all quotes out, then you'd likely end up with an otherwise hard-to-use blob of plaintext. Maybe this is what you *really want*, but I'm doubtful that it's that simple.
Yes, I understand. But it's requirement that hey want a format of file without quotes as this file upload somewhere and without quotes only work according to format.
Well, you can always read the CSV file into Appian then use the Text from Template node to construct a brand new file in whatever format you want, even if it's just the same values exported as-is with just commas separating them and no additional formatting.
Does this mean I need to use one more node "Text Doc from Template" to achieve this?
Given that you seem to want a text file as an output, then yes, this is probably the most direct approach.
That make sense. But here is one doubt. When CSV file is generated- a document link is provided to download that CSV file. That same CSV file user is opened in editor as well that will upload in some portal. How and where can I provide that new document link?This "testfile" is basically a link of csv file which will download on click of this link. This same file user will open in notepad and upload in portal.
manjit.1486 said:How and where can I provide that new document link?
I'm not really sure I understand the problem here. If you create a separate TXT file based on the contents of the CSV (just with double-quotes replaced with null), you can show that (new) document in any location or method you wish.
That's the problem. They do not want to show any other link or document.
Then why would you even need the extra TXT file?
I was hoping to achieve file without quotes. Is it possible to open that CSV file in editor without quotes without providing extra link?