email parsing automation

Email Parser

Extract data from emails and automate your workflow

The forum is now read only. Please, go to the the main Email Parser website if you need help.
Post your ideas here. Suggestions are welcome.
Hello,

In the automated processes is it possible to write to CSV file instead of text or Excel .xlsx files? I need to write the parsed information in a csv file. How can I do that?

Thanks for your help in advance.
Did you ever get this resolved?

My solution was to create an automated process using the write to text file option.

In the file name, give the file whatevername.csv. You could also use the .txt for the extension, then rename to .csv after the parser ran.

In the text to insert, for text fields, you put the " (double quote), your field name, another ", then comma.

If the field is a numeric type field, omit the two quotes.

Example:
"<%FIELD1%>","<%FIELD2%>",<%FIELD3%>, "<%FIELD4%>"

Field1, Field2, and Field4 are character strings; Field3 is number.
Thanks Vanmark. Yes, that is exactly the way to go.
create_csv_file_from_parsed_fields_from_email.jpg