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
NOTE, if you are only removing quotes from the CSV file, you may be left with values within the quotes that contain a comma that is not intended to be used as a delimiter, this will break your entire file. This is the purpose of quoting all values within a CSV, which is essentially a standard that all systems designed to accept CSV should honor, in my opinion.
And what is the data like that is coming into the initial HTML node, from a DB query etc? Can you utilize an expression rule to build the CSV file?
In all the CSV files I create, I generate the contents via an expression rule, which gives you full control over the output, then run that into a Text Doc from Template node which only has one placeholder (for the entire text). As I type this however I realize that all of my CSV files are SFTP'd out, which is where I convert them from .txt to .csv, I'm not sure if we have an other way to change file types in Appian..
I am taking data from process variables. because at this time data is not saved into database which is the reason I am not using Export data store entity to CSV. What I have done. I have used node HTML Doc from Template. In this template I have designed a table form data as mentioned below..
<HTML> <head></head> <BODY> <form> <table name="Add" style="border:2px solid black" width="100%" border="1" cellpadding="5" cellspacing="0"> <tr> <th><label> <b> Name </b> </label> </th> <th><label> <b> Date </b> </label> </th> <th><label> <b> Address </b> </label></th> <th><label> <b> Department </b> </label></th> <th><label> <b> Country </b> </label> </th> </tr> ###details### </table> </form> </BODY> </HTML>
HI Mike Schmitt can you guide this thing? Is it possible to change the extension of text file into CSV?Like I am able to achieve the text document from that smart service. Can we update the extension of that documnet to CSV?
You can TRY to put in the full output file name like "myExport.CSV", but Appian does not always give THAT much control over file extensions (and no direct means by which to CHANGE the extension of an existing file, that I know of). However I feel I need to point out one more time that the resulting file you're creating is NOT A CSV FILE any more, because removing the quotes breaks all CSV file conventions.
I agree. I will try if that works. Does this mean output file name?
in many (but not all) document generation smart services, one of the input parameters will be something like "generated file name", and govern what the actual filename is for the generated doc. The thing in your screenshot will be a reference to the generated doc ID (to be saved into a "document type" pv, as a reference to the created document itself), so not the same thing.
In the "text from template" node, it's in the Setup (highlighted). I'm unclear whether providing a name (dot) extension here will allow you to override the default ".txt" extension (i'd guess no, but you can still try and see what happens).
Nothing happened. I tried with "CSV.csv" and .csv
We can achieve this ting by using CSV file template in "Text doc from template smart service". It worked.
Sorry, yes now that you mention it, I did know that would be a workable alternative: namely, to create a (text) template that's actually a filename with ".csv" extension. Appian doesn't enforce the extension (and keeps the original) despite it being "text from template".
I reiterate my original warning that the file you're generating here is no longer an actual CSV file (despite the extension you're keeping), since the quoted fields are a part of the CSV file format for parsing sake. If you're lucky the resulting file might still parse correctly by a CSV reader.
Yes. Actually it was the same result of CSV file that I got before. Therefore, CSV file seems to be perfect and parsed properly, also in editor I can this file without quotes.
Can anyone guide how to remove these commas from this file? This file is basically a CSV file that I open in editor.
AFAIK those commas indicate the presence of columns (exported to the CSV) that didn't have any data in them. You could always just pass the text through some function that removes any comma(s) at the end of a line of text... but it might be more worth your time investingating why they're appearing in the first place.
= a!localVariables( local!data: pv!empDetails, local!uniqueName: union( local!data.name, local!data.name ), joinarray( a!forEach( items: local!uniqueName, expression: a!localVariables( local!currentUserIndices: wherecontains( fv!item, touniformstring(local!data.name) ), concat( union( local!data.name_txt, local!data.name_txt ) , ",", union( local!data.address_txt, local!data.address_txt ) , ",", local!data.dept, ",", local!data.side, ",", local!data.city, ) ) ), char(13) & char(10) ) )
Actually, it suddenly appears, Earlier it was working fine- although, I have checked the previous versions as well. But no difference in code. Can you(Mike Schmitt ) please go through the code?
it seems like it's adding a whole extra set of blanks at the end (along with the hardcoded commas you have separating them), though the exact cause is a little hard to tell without seeing an example value for "pv!empDetails".