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?
You won't be able to make any edits to the original CSV file in Appian (and if you removed the quotes somehow, it would no longer *actually* be a "CSV" file, since the quotes are a required part of the parsing). If you're hoping to ONLY show the end user the result with the quotes stripped, you would probably be able to have the "generate CSV" process also take the resulting CSV, read the information in as text, strip double quotes, dump the results back into a (new) TXT file, then **only** show that on the user's interface. If the user was expecting a "CSV" though that isn't what they'll be getting anymore, so I would consider renaming the "generate CSV" button as well while making these other changes.
Note: I'm fuzzy on how easy / possible it is to read data as text from a CSV file, but i'm pretty sure that after you have the resulting information, it'll be pretty simple to use the "text from template" smart service and drop the resulting rows of text into a new text file. This can be displayed on-form pretty easily (i'm not sure what you mean by "editor" though).
I tried to read data using smart service Txt from template. It worked. The problem is one file they need which is CSV and and can be edited in notepad without quotes.
If you remove the quotes, it's not a CSV file anymore. If someone is telling you otherwise, you should escalate this requirement high enough to get someone who understands the technical details, because this makes very little sense as-is.