ProcessFlow to parse csv file

 3 Replies
 1 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
slavo
Basic Member
Posts: 8
Basic Member
I am relatively inexperienced as a PF designer, I need to parse an input csv file, parse the fields out and write them to a SQL server table.  This should be very easy but I cannot figure out the Data Iterator node at all.  If someone has a simple flow they can shar, I would be very grateful.  CFan email me an example if possible to: slavom@hotmail.com



M Graham
Veteran Member
Posts: 32
Veteran Member
New Poster
New Poster
Congrats on posting!
I use 2 DataIterator nodes to parse the fields in an input csv file and will email you an example. 
1. The 1st Data Interator node parameters:
    Input Method:  File
    Input File:  (enter your file name and directory)
    Parse by: Line
2. The 2nd Data Interator node is nested inside the 1st Data Iterator node:
     Input Method:  Data
     Input Data: 
     Parse by:  Delimiter String
     Delimiter String:  , (enter a comma symbol if the fields in your csv file are separated by a comma).
M Graham
Veteran Member
Posts: 32
Veteran Member
New Poster
New Poster
Congrats on posting!
2nd try - This post didn't display my text for the "Input Data" parameter because I enclosed the text between symbols for "greater than" and "less than.  Here are the parameters again:
2. The 2nd Data Interator node is nested inside the 1st Data Iterator node:
     Input Method:  Data
     Input Data:  !FileIn_outputData  - be sure to enclose this text between 'greater than' and 'less than' symbols.<!--leIn_outputDa-->
     Parse by:  Delimiter String
     Delimiter String:  , (enter a comma symbol if the fields in your csv file are separated by a comma).
Kevin Cubillas
Basic Member
Posts: 9
Basic Member
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
The Memorial Patient Refund flow does this. Just have Diana R. email it to your.