PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/04/2015 4:23 PM by  GeoffTSJY
Parse CSV Comma Delimited File with Quotes and Embedded Comma
 9 Replies
Sort:
You are not authorized to post a reply.
Author Messages
agersh
Systems Analyst
Martin Health System
Veteran Member
(126 points)
Veteran Member
Posts:64


Send Message:

--
03/06/2014 10:28 AM

    Using the Data Iterator node I've been trying to figure out how I can parse the following CSV file/row, Comma Delimited with Quotes and Embedded Comma.

    "1375","Annual","GRETA","GOLD","082189","Yes","REGINA","BRONZ","01/21/2014","BRONZ, REGINA;FRANKEN, JANET","TRANSCRIPTIONIST PATHOLOGY","12354","Yes","No","Yes","","","Submitted to HR","","","","2.03","01/21/2014","01/21/2014","0.00","0.00","0.00","","","01/21/2014"

    Has anyone else come across this situation?

     
    Kyle Jorgensen
    Programmer/Analyst
    WoodmenLife
    Veteran Member
    (308 points)
    Veteran Member
    Posts:114


    Send Message:

    --
    03/06/2014 10:51 AM
    I've haven't tried this, but can you make the delimter character more than 1 character. If so, make the delimiter quote-comman-quote: ","

    Then you'd just have to trim off the leading and trailing quotes on the line.
    BarbLR
    Systems Architect
    Munson Healthcare
    Veteran Member
    (888 points)
    Veteran Member
    Posts:306


    Send Message:

    --
    03/06/2014 10:51 AM
    I haven't had the situation, but I guess the first thing I'd try is using "," as my delimiter string in the second Data Iterator node. Then in the assign of my first variable I'd always substring to start with position 2 to skip the starting " and my last variable to drop the trailing ".
    Kyle Jorgensen
    Programmer/Analyst
    WoodmenLife
    Veteran Member
    (308 points)
    Veteran Member
    Posts:114


    Send Message:

    --
    03/06/2014 10:58 AM
    yep, just tried it and it works. play with it some. i had to trim the leading quote, but not the trailing quote on the line.
    John Henley
    Private
    Private
    Senior Member
    (9587 points)
    Senior Member
    Posts:3213


    Send Message:

    --
    03/06/2014 11:07 AM
    Thanks for using the LawsonGuru.com forums!
    John
    GeoffTSJY
    HRIS Applications Developer
    Private
    Basic Member
    (48 points)
    Basic Member
    Posts:16


    Send Message:

    --
    07/31/2015 5:22 PM
    Easy way to do this is just use the javascript library. There is a String function called split. You tell it what character to split by and the result is an array.

    Here is my code:

    //read in all of your data to a single variable. Since I did this literally and not from a file I had to escape all of the quotes with / so they wouldn't be confused at actual quotes of the string definition.
    t1 = "\"1375\",\"Annual\",\"GRETA\",\"GOLD\",\"082189\",\"Yes\",\"REGINA\",\"BRONZ\",\"01/21/2014\",\"BRONZ, REGINA;FRANKEN, JANET\",\"TRANSCRIPTIONIST PATHOLOGY\",\"12354\",\"Yes\",\"No\",\"Yes\",\"\",\"\",\"Submitted to HR\",\"\",\"\",\"\",\"2.03\",\"01/21/2014\",\"01/21/2014\",\"0.00\",\"0.00\",\"0.00\",\"\",\"\",\"01/21/2014\"";

    //I made an array type in the start node
    myArr = t1.split(","); //this tells it to split the string t1 into an array by separating from each comma.

    //The array is returned and stored in myArr because of the assignment "="
    //to show you that I got them all
    t2 = myArr.length

    //to show you a sample of how one of them is stored in the array variable
    //this is the first item in the array
    //t3 = myArr[0]

    //another item. this is the 2nd item. The 32nd item would be myArr[31]
    t4 = myArr[1] 

    Here is my results:
    Activity completed: Start
    Activity started: Assign4770 (Run Id: 4)
    t1 = "1375","Annual","GRETA","GOLD","082189","Yes","REGINA","BRONZ","01/21/2014","BRONZ, REGINA;FRANKEN, JANET","TRANSCRIPTIONIST PATHOLOGY","12354","Yes","No","Yes","","","Submitted to HR","","","","2.03","01/21/2014","01/21/2014","0.00","0.00","0.00","","","01/21/2014"

    myArr = "1375","Annual","GRETA","GOLD","082189","Yes","REGINA","BRONZ","01/21/2014","BRONZ, REGINA;FRANKEN, JANET","TRANSCRIPTIONIST PATHOLOGY","12354","Yes","No","Yes","","","Submitted to HR","","","","2.03","01/21/2014","01/21/2014","0.00","0.00","0.00","","","01/21/2014"

    t2 = 32
    t3 = "1375"
    t4 = "Annual"
    Activity completed: Assign4770 

    Then for the DataIterator use a ForEach instead. Set to Array in the general tab under "Select Option".
    Then in the "Array Input" put your array name. I put myArr in for my example. Then connect the for each start directly to the end and you're done. Look at what you get: (I put the first couple in bold to show you where the output is in the log. Just use that variable for whatever you're trying to do between the start and end of the foreach. In my case that variable is "ForEach6390_arrayValue ")

    Activity started: ForEach6390  (Run Id: 3)
    ForLoop ForEach6390: Executing
    <strong>ForEach6390_arrayValue = "1375"</strong>
    ForEach6390_iterationNumber = 1
    ForLoop ForEach6390: Iteration 1
    Activity started: End-ForEach6390  (Run Id: 0)
    <strong>ForEach6390_arrayValue = "Annual"</strong>
    ForEach6390_iterationNumber = 2
    ForLoop ForEach6390: Iteration 2
    Activity started: End-ForEach6390  (Run Id: 0)
    <strong>ForEach6390_arrayValue = "GRETA"</strong>
    ForEach6390_iterationNumber = 3
    ForLoop ForEach6390: Iteration 3
    Activity started: End-ForEach6390  (Run Id: 0)
    <strong>ForEach6390_arrayValue = "GOLD"</strong>
    ForEach6390_iterationNumber = 4
    ForLoop ForEach6390: Iteration 4
    Activity started: End-ForEach6390  (Run Id: 0)
    <strong>ForEach6390_arrayValue = "082189"</strong>
    ForEach6390_iterationNumber = 5
    ForLoop ForEach6390: Iteration 5
    Activity started: End-ForEach6390  (Run Id: 0)
    <strong>ForEach6390_arrayValue = "Yes"</strong>
    ForEach6390_iterationNumber = 6
    ForLoop ForEach6390: Iteration 6
    Activity started: End-ForEach6390  (Run Id: 0)
    <strong>ForEach6390_arrayValue = "REGINA"</strong>
    ForEach6390_iterationNumber = 7
    ForLoop ForEach6390: Iteration 7
    Activity started: End-ForEach6390  (Run Id: 0)
    <strong>ForEach6390_arrayValue = "BRONZ"</strong>
    ForEach6390_iterationNumber = 8
    ForLoop ForEach6390: Iteration 8
    Activity started: End-ForEach6390  (Run Id: 0)
    <strong>ForEach6390_arrayValue = "01/21/2014"</strong>
    ForEach6390_iterationNumber = 9
    ForLoop ForEach6390: Iteration 9
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = "BRONZ
    ForEach6390_iterationNumber = 10
    ForLoop ForEach6390: Iteration 10
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue =  REGINA;FRANKEN
    ForEach6390_iterationNumber = 11
    ForLoop ForEach6390: Iteration 11
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue =  JANET"
    ForEach6390_iterationNumber = 12
    ForLoop ForEach6390: Iteration 12
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = "TRANSCRIPTIONIST PATHOLOGY"
    ForEach6390_iterationNumber = 13
    ForLoop ForEach6390: Iteration 13
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = "12354"
    ForEach6390_iterationNumber = 14
    ForLoop ForEach6390: Iteration 14
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = "Yes"
    ForEach6390_iterationNumber = 15
    ForLoop ForEach6390: Iteration 15
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = "No"
    ForEach6390_iterationNumber = 16
    ForLoop ForEach6390: Iteration 16
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = "Yes"
    ForEach6390_iterationNumber = 17
    ForLoop ForEach6390: Iteration 17
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = ""
    ForEach6390_iterationNumber = 18
    ForLoop ForEach6390: Iteration 18
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = ""
    ForEach6390_iterationNumber = 19
    ForLoop ForEach6390: Iteration 19
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = "Submitted to HR"
    ForEach6390_iterationNumber = 20
    ForLoop ForEach6390: Iteration 20
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = ""
    ForEach6390_iterationNumber = 21
    ForLoop ForEach6390: Iteration 21
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = ""
    ForEach6390_iterationNumber = 22
    ForLoop ForEach6390: Iteration 22
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = ""
    ForEach6390_iterationNumber = 23
    ForLoop ForEach6390: Iteration 23
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = "2.03"
    ForEach6390_iterationNumber = 24
    ForLoop ForEach6390: Iteration 24
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = "01/21/2014"
    ForEach6390_iterationNumber = 25
    ForLoop ForEach6390: Iteration 25
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = "01/21/2014"
    ForEach6390_iterationNumber = 26
    ForLoop ForEach6390: Iteration 26
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = "0.00"
    ForEach6390_iterationNumber = 27
    ForLoop ForEach6390: Iteration 27
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = "0.00"
    ForEach6390_iterationNumber = 28
    ForLoop ForEach6390: Iteration 28
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = "0.00"
    ForEach6390_iterationNumber = 29
    ForLoop ForEach6390: Iteration 29
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = ""
    ForEach6390_iterationNumber = 30
    ForLoop ForEach6390: Iteration 30
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = ""
    ForEach6390_iterationNumber = 31
    ForLoop ForEach6390: Iteration 31
    Activity started: End-ForEach6390  (Run Id: 0)
    ForEach6390_arrayValue = "01/21/2014"
    ForEach6390_iterationNumber = 32
    ForLoop ForEach6390: Iteration 32
    Activity started: End-ForEach6390  (Run Id: 0)
    Activity started: End-ForEach6390  (Run Id: 0)
    Activity completed: ForEach6390
    
    Peter O
    Systems Analyst
    Independent
    Veteran Member
    (205 points)
    Veteran Member
    Posts:69


    Send Message:

    --
    08/04/2015 2:58 PM

    Pretty good solution if you have strict data guidelines (comma control ). Unfortunately it looks like your solution would break if they used a field that allowed commas.

     

    Example:

    t1 = "1375","Annual","GRETA","GOLD","082189","Yes","REGINA","BRONZ","01/21/2014","BRONZ, REGINA;FRANKEN, JANET","TRANSCRIPTIONIST, PATHOLOGY","12354","Yes","No","Yes","","","Submitted to HR, other text here.","","","","2.03","01/21/2014","01/21/2014","0.00","0.00","0.00","","","01/21/2014"
    

    I modified the example variable slightly, but it's still valid in a CSV file. The example above, when parsed by splitting on commas, will break data up into unintended columns.

     

    GeoffTSJY
    HRIS Applications Developer
    Private
    Basic Member
    (48 points)
    Basic Member
    Posts:16


    Send Message:

    --
    08/04/2015 3:47 PM
    You can accommodate for this with a regex to replace the csv delimiter with a custom delimiter. Your replacement delimiter should be something that you are confident won't be in your actual data.

    //if your csv delimiter string doesn't have "," always exactly the same, you can actually do more regex and replace to
    //make it the same and then do this process. It depends on how reliable your csv formatting is if that is necessary.
    t1 = t1.replace(/","/g, '%R0Wd3l1m1t3r%'); //replace with your own delimiter
    t1 = t1.replace(/"/g, ''); //replace the front and back quotes
    myArr = t1.split('%R0Wd3l1m1t3r%');
    <p>&nbsp;</p>
    <p>//here is the output<br />
    <br />
    [Activity started: ForEach2890  (Run Id: 1)
    ForLoop ForEach2890: Executing
    ForEach2890_arrayValue = 1375
    ForEach2890_iterationNumber = 1
    ForLoop ForEach2890: Iteration 1
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = Annual
    ForEach2890_iterationNumber = 2
    ForLoop ForEach2890: Iteration 2
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = GRETA
    ForEach2890_iterationNumber = 3
    ForLoop ForEach2890: Iteration 3
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = GOLD
    ForEach2890_iterationNumber = 4
    ForLoop ForEach2890: Iteration 4
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = 082189
    ForEach2890_iterationNumber = 5
    ForLoop ForEach2890: Iteration 5
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = Yes
    ForEach2890_iterationNumber = 6
    ForLoop ForEach2890: Iteration 6
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = REGINA
    ForEach2890_iterationNumber = 7
    ForLoop ForEach2890: Iteration 7
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = BRONZ
    ForEach2890_iterationNumber = 8
    ForLoop ForEach2890: Iteration 8
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = 01/21/2014
    ForEach2890_iterationNumber = 9
    ForLoop ForEach2890: Iteration 9
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = BRONZ, REGINA;FRANKEN, JANET
    ForEach2890_iterationNumber = 10
    ForLoop ForEach2890: Iteration 10
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = TRANSCRIPTIONIST, PATHOLOGY
    ForEach2890_iterationNumber = 11
    ForLoop ForEach2890: Iteration 11
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = 12354
    ForEach2890_iterationNumber = 12
    ForLoop ForEach2890: Iteration 12
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = Yes
    ForEach2890_iterationNumber = 13
    ForLoop ForEach2890: Iteration 13
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = No
    ForEach2890_iterationNumber = 14
    ForLoop ForEach2890: Iteration 14
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = Yes
    ForEach2890_iterationNumber = 15
    ForLoop ForEach2890: Iteration 15
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue =
    ForEach2890_iterationNumber = 16
    ForLoop ForEach2890: Iteration 16
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue =
    ForEach2890_iterationNumber = 17
    ForLoop ForEach2890: Iteration 17
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = Submitted to HR, other text here.
    ForEach2890_iterationNumber = 18
    ForLoop ForEach2890: Iteration 18
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue =
    ForEach2890_iterationNumber = 19
    ForLoop ForEach2890: Iteration 19
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue =
    ForEach2890_iterationNumber = 20
    ForLoop ForEach2890: Iteration 20
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue =
    ForEach2890_iterationNumber = 21
    ForLoop ForEach2890: Iteration 21
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = 2.03
    ForEach2890_iterationNumber = 22
    ForLoop ForEach2890: Iteration 22
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = 01/21/2014
    ForEach2890_iterationNumber = 23
    ForLoop ForEach2890: Iteration 23
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = 01/21/2014
    ForEach2890_iterationNumber = 24
    ForLoop ForEach2890: Iteration 24
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = 0.00
    ForEach2890_iterationNumber = 25
    ForLoop ForEach2890: Iteration 25
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = 0.00
    ForEach2890_iterationNumber = 26
    ForLoop ForEach2890: Iteration 26
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = 0.00
    ForEach2890_iterationNumber = 27
    ForLoop ForEach2890: Iteration 27
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue =
    ForEach2890_iterationNumber = 28
    ForLoop ForEach2890: Iteration 28
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue =
    ForEach2890_iterationNumber = 29
    ForLoop ForEach2890: Iteration 29
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = 01/21/2014
    ForEach2890_iterationNumber = 30
    ForLoop ForEach2890: Iteration 30
    Activity started: End-ForEach2890  (Run Id: 0)
    Activity started: End-ForEach2890  (Run Id: 0)
    Activity completed: ForEach2890
    

    GeoffTSJY
    HRIS Applications Developer
    Private
    Basic Member
    (48 points)
    Basic Member
    Posts:16


    Send Message:

    --
    08/04/2015 4:14 PM
    I should note that in my first solution, there was also a problem that the quotes were actually part of the data. Using replace and/or just a different split argument could take care of that.

    Now you could also read in all of your data in at once into an array. Then make each item in that array be an array. This is called a multidimensional array. If you were to draw it out, you'd have a table, just like in excel spreadsheets. Really all CSVs are are multidimensional arrays.

    Now do a foreach node inside of a foreach node. The outer foreach will be set to array and input will be rowArr.

    The inner foreach node will be set to array and input will be <!--rowArr[ForEach2890_iterationNumber -1]-->

    Where ForEach2890 is the outer foreach node. You have to do -1 on the iteration number because lawson counts the first record as 1 but in computer science the first number is always 0. So -1 makes those the same.

    You'll notice in my output. The outer 2890 runs start iteration 1 and then goes through all of that row. Then goes to iteration 2 and then does all of the 2nd row. BTW, the first row was the original data and the 2nd row is the data modded by Peter.

    //rowArr is just an array I made empty in the start node
    //first split the entire dataset by the newline character.
    //each item in this array is an entire row of data
    rowArr = t1.split('\n');
    //now go row by row
    for each (var i in rowArr) {
    var tmp = new String(rowArr<i>); //put the row in a temp string
    tmp = tmp.replace(/","/g, '%R0Wd3l1m1t3r%'); //fix delimiter
    tmp = tmp.replace(/"/g, ''); //fix delimiter #2
    rowArr<i> = tmp.split('%R0Wd3l1m1t3r%'); //split by our delimiter
    } //go on to the next row
    //here is the output
    Activity started: ForEach2890  (Run Id: 3)
    ForLoop ForEach2890: Executing
    ForEach2890_arrayValue = "1375","Annual","GRETA","GOLD","082189","Yes","REGINA","BRONZ","01/21/2014","BRONZ, REGINA;FRANKEN, JANET","TRANSCRIPTIONIST, PATHOLOGY","12354","Yes","No","Yes","","","Submitted to HR, other text here.","","","","2.03","01/21/2014","01/21/2014","0.00","0.00","0.00","","","01/21/2014"
    ForEach2890_iterationNumber = 1
    ForLoop ForEach2890: Iteration 1
    Activity started: ForEach5270  (Run Id: 4)
    ForLoop ForEach5270: Executing
    ForEach5270_arrayValue = "1375"
    ForEach5270_iterationNumber = 1
    ForLoop ForEach5270: Iteration 1
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "Annual"
    ForEach5270_iterationNumber = 2
    ForLoop ForEach5270: Iteration 2
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "GRETA"
    ForEach5270_iterationNumber = 3
    ForLoop ForEach5270: Iteration 3
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "GOLD"
    ForEach5270_iterationNumber = 4
    ForLoop ForEach5270: Iteration 4
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "082189"
    ForEach5270_iterationNumber = 5
    ForLoop ForEach5270: Iteration 5
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "Yes"
    ForEach5270_iterationNumber = 6
    ForLoop ForEach5270: Iteration 6
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "REGINA"
    ForEach5270_iterationNumber = 7
    ForLoop ForEach5270: Iteration 7
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "BRONZ"
    ForEach5270_iterationNumber = 8
    ForLoop ForEach5270: Iteration 8
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "01/21/2014"
    ForEach5270_iterationNumber = 9
    ForLoop ForEach5270: Iteration 9
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "BRONZ
    ForEach5270_iterationNumber = 10
    ForLoop ForEach5270: Iteration 10
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue =  REGINA;FRANKEN
    ForEach5270_iterationNumber = 11
    ForLoop ForEach5270: Iteration 11
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue =  JANET"
    ForEach5270_iterationNumber = 12
    ForLoop ForEach5270: Iteration 12
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "TRANSCRIPTIONIST
    ForEach5270_iterationNumber = 13
    ForLoop ForEach5270: Iteration 13
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue =  PATHOLOGY"
    ForEach5270_iterationNumber = 14
    ForLoop ForEach5270: Iteration 14
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "12354"
    ForEach5270_iterationNumber = 15
    ForLoop ForEach5270: Iteration 15
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "Yes"
    ForEach5270_iterationNumber = 16
    ForLoop ForEach5270: Iteration 16
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "No"
    ForEach5270_iterationNumber = 17
    ForLoop ForEach5270: Iteration 17
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "Yes"
    ForEach5270_iterationNumber = 18
    ForLoop ForEach5270: Iteration 18
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = ""
    ForEach5270_iterationNumber = 19
    ForLoop ForEach5270: Iteration 19
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = ""
    ForEach5270_iterationNumber = 20
    ForLoop ForEach5270: Iteration 20
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "Submitted to HR
    ForEach5270_iterationNumber = 21
    ForLoop ForEach5270: Iteration 21
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue =  other text here."
    ForEach5270_iterationNumber = 22
    ForLoop ForEach5270: Iteration 22
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = ""
    ForEach5270_iterationNumber = 23
    ForLoop ForEach5270: Iteration 23
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = ""
    ForEach5270_iterationNumber = 24
    ForLoop ForEach5270: Iteration 24
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = ""
    ForEach5270_iterationNumber = 25
    ForLoop ForEach5270: Iteration 25
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "2.03"
    ForEach5270_iterationNumber = 26
    ForLoop ForEach5270: Iteration 26
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "01/21/2014"
    ForEach5270_iterationNumber = 27
    ForLoop ForEach5270: Iteration 27
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "01/21/2014"
    ForEach5270_iterationNumber = 28
    ForLoop ForEach5270: Iteration 28
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "0.00"
    ForEach5270_iterationNumber = 29
    ForLoop ForEach5270: Iteration 29
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "0.00"
    ForEach5270_iterationNumber = 30
    ForLoop ForEach5270: Iteration 30
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "0.00"
    ForEach5270_iterationNumber = 31
    ForLoop ForEach5270: Iteration 31
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = ""
    ForEach5270_iterationNumber = 32
    ForLoop ForEach5270: Iteration 32
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = ""
    ForEach5270_iterationNumber = 33
    ForLoop ForEach5270: Iteration 33
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "01/21/2014"
    ForEach5270_iterationNumber = 34
    ForLoop ForEach5270: Iteration 34
    Activity started: End-ForEach5270  (Run Id: 0)
    Activity started: End-ForEach5270  (Run Id: 0)
    Activity completed: ForEach5270
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue = "1375","Annual","GRETA","GOLD","082189","Yes","REGINA","BRONZ","01/21/2014","BRONZ, REGINA;FRANKEN, JANET","TRANSCRIPTIONIST PATHOLOGY","12354","Yes","No","Yes","","","Submitted to HR","","","","2.03","01/21/2014","01/21/2014","0.00","0.00","0.00","","","01/21/2014"
    ForEach2890_iterationNumber = 2
    ForLoop ForEach2890: Iteration 2
    Activity started: ForEach5270  (Run Id: 5)
    ForLoop ForEach5270: Executing
    ForEach5270_arrayValue = "1375"
    ForEach5270_iterationNumber = 1
    ForLoop ForEach5270: Iteration 1
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "Annual"
    ForEach5270_iterationNumber = 2
    ForLoop ForEach5270: Iteration 2
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "GRETA"
    ForEach5270_iterationNumber = 3
    ForLoop ForEach5270: Iteration 3
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "GOLD"
    ForEach5270_iterationNumber = 4
    ForLoop ForEach5270: Iteration 4
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "082189"
    ForEach5270_iterationNumber = 5
    ForLoop ForEach5270: Iteration 5
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "Yes"
    ForEach5270_iterationNumber = 6
    ForLoop ForEach5270: Iteration 6
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "REGINA"
    ForEach5270_iterationNumber = 7
    ForLoop ForEach5270: Iteration 7
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "BRONZ"
    ForEach5270_iterationNumber = 8
    ForLoop ForEach5270: Iteration 8
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "01/21/2014"
    ForEach5270_iterationNumber = 9
    ForLoop ForEach5270: Iteration 9
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "BRONZ
    ForEach5270_iterationNumber = 10
    ForLoop ForEach5270: Iteration 10
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue =  REGINA;FRANKEN
    ForEach5270_iterationNumber = 11
    ForLoop ForEach5270: Iteration 11
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue =  JANET"
    ForEach5270_iterationNumber = 12
    ForLoop ForEach5270: Iteration 12
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "TRANSCRIPTIONIST PATHOLOGY"
    ForEach5270_iterationNumber = 13
    ForLoop ForEach5270: Iteration 13
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "12354"
    ForEach5270_iterationNumber = 14
    ForLoop ForEach5270: Iteration 14
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "Yes"
    ForEach5270_iterationNumber = 15
    ForLoop ForEach5270: Iteration 15
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "No"
    ForEach5270_iterationNumber = 16
    ForLoop ForEach5270: Iteration 16
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "Yes"
    ForEach5270_iterationNumber = 17
    ForLoop ForEach5270: Iteration 17
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = ""
    ForEach5270_iterationNumber = 18
    ForLoop ForEach5270: Iteration 18
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = ""
    ForEach5270_iterationNumber = 19
    ForLoop ForEach5270: Iteration 19
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "Submitted to HR"
    ForEach5270_iterationNumber = 20
    ForLoop ForEach5270: Iteration 20
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = ""
    ForEach5270_iterationNumber = 21
    ForLoop ForEach5270: Iteration 21
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = ""
    ForEach5270_iterationNumber = 22
    ForLoop ForEach5270: Iteration 22
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = ""
    ForEach5270_iterationNumber = 23
    ForLoop ForEach5270: Iteration 23
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "2.03"
    ForEach5270_iterationNumber = 24
    ForLoop ForEach5270: Iteration 24
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "01/21/2014"
    ForEach5270_iterationNumber = 25
    ForLoop ForEach5270: Iteration 25
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "01/21/2014"
    ForEach5270_iterationNumber = 26
    ForLoop ForEach5270: Iteration 26
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "0.00"
    ForEach5270_iterationNumber = 27
    ForLoop ForEach5270: Iteration 27
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "0.00"
    ForEach5270_iterationNumber = 28
    ForLoop ForEach5270: Iteration 28
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "0.00"
    ForEach5270_iterationNumber = 29
    ForLoop ForEach5270: Iteration 29
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = ""
    ForEach5270_iterationNumber = 30
    ForLoop ForEach5270: Iteration 30
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = ""
    ForEach5270_iterationNumber = 31
    ForLoop ForEach5270: Iteration 31
    Activity started: End-ForEach5270  (Run Id: 0)
    ForEach5270_arrayValue = "01/21/2014"
    ForEach5270_iterationNumber = 32
    ForLoop ForEach5270: Iteration 32
    Activity started: End-ForEach5270  (Run Id: 0)
    Activity started: End-ForEach5270  (Run Id: 0)
    Activity completed: ForEach5270
    Activity started: End-ForEach2890  (Run Id: 0)
    ForEach2890_arrayValue =
    ForEach2890_iterationNumber = 3
    ForLoop ForEach2890: Iteration 3
    Activity started: ForEach5270  (Run Id: 6)
    ForLoop ForEach5270: Executing
    ForEach5270_arrayValue =
    ForEach5270_iterationNumber = 1
    ForLoop ForEach5270: Iteration 1
    Activity started: End-ForEach5270  (Run Id: 0)
    Activity started: End-ForEach5270  (Run Id: 0)
    Activity completed: ForEach5270
    Activity started: End-ForEach2890  (Run Id: 0)
    Activity started: End-ForEach2890  (Run Id: 0)
    Activity completed: ForEach2890
    
    GeoffTSJY
    HRIS Applications Developer
    Private
    Basic Member
    (48 points)
    Basic Member
    Posts:16


    Send Message:

    --
    08/04/2015 4:23 PM
    Bah, this last one screwed up. Sorry, I don't have time to fix it right now. Hopefully you get the idea. This is part of the process though. I should only need to do a regex to make sure my input string is consistently formatted before my parsing. That shouldn't be hard to do. Maybe I'll update this later. But I have to get back to other stuff. Sorry!
    You are not authorized to post a reply.