SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

How do I create a csv file output that can be pasted into a wiki document

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

How do I create a csv file output that can be pasted into a wiki document

I have a job in DM studio that contains a branch that breaks out several nodes into separate output files.  From there I need to take the data from the output files and paste it or somehow get it into a wiki document as a table.  Currently we have an excel macro that reformats the data by placing pipes at the beginning, double pipes between cells/columns, creates a hard carriage return followed by "|-" after each row.  That data is then placed into the wiki and it recognizes the hard carriage return and |- and creates a new row.  I can't figure out a way to create the output of a data job in DM studio that will do this for me automatically. 


Accepted Solutions
Solution
‎02-21-2017 08:03 AM
New Contributor
Posts: 4

Re: How do I create a csv file output that can be pasted into a wiki document

Posted in reply to beamer108

I was able to find a workaround, may not be the best or only option but it works temporarily.  I used the concatenation node and added <TR Class = "rowon" and <td> at the beginning of my list. Then after each separate field I inserted </td><td> to end and start a new field. I ended the list with </tr>.  I ran that node into a text file output.  Once that runs, I copy and paste those results into my wiki page that has been pre-built with the headers etc.  The information gets pasted into the "body" of the wiki.  This seems to be the best solution that I have found, but interested in other options down the road to enhance this if anyone has ideas.  Thank you for your help!

View solution in original post


All Replies
Super User
Posts: 19,772

Re: How do I create a csv file output that can be pasted into a wiki document

Posted in reply to beamer108

How are you creating the csv? A data step should be able to do this. 

New Contributor
Posts: 4

Re: How do I create a csv file output that can be pasted into a wiki document

Using a text file output node.  Maybe this isn't the best way to accomplish what my goal is but it's what I have right now. If there is a different way to get this done Im interested. 

New Contributor
Posts: 4

Re: How do I create a csv file output that can be pasted into a wiki document

Posted in reply to beamer108

I should add that I used a concatenation node prior to the text file output to add a single pipe at the beginning of a row and double pipes between columns which works perfectly when I paste it into the wiki, it puts each of the cells in the correct columns but it doesn't hard break it to start a new row. Everything continues on in the same row. 

Solution
‎02-21-2017 08:03 AM
New Contributor
Posts: 4

Re: How do I create a csv file output that can be pasted into a wiki document

Posted in reply to beamer108

I was able to find a workaround, may not be the best or only option but it works temporarily.  I used the concatenation node and added <TR Class = "rowon" and <td> at the beginning of my list. Then after each separate field I inserted </td><td> to end and start a new field. I ended the list with </tr>.  I ran that node into a text file output.  Once that runs, I copy and paste those results into my wiki page that has been pre-built with the headers etc.  The information gets pasted into the "body" of the wiki.  This seems to be the best solution that I have found, but interested in other options down the road to enhance this if anyone has ideas.  Thank you for your help!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 251 views
  • 0 likes
  • 2 in conversation