Dorota
Member
This is happening in E8.12
I am using B98220D Parse Delimited String to load values from the CSV table into variables. I can see that the input record is complete, I have 66 columns, comma delimited.
However, I can see in the debug that on column 20, values stop coming through.
VA rpt_FlatFileRecord_FFRC Input string (verified in the debug that it is complete) looks like this:
,3/1/2023,3/6/2023,3/13/2023,3/20/2023,3/27/2023,4/1/2023,4/3/2023,4/10/2023,4/17/2023,4/24/2023,5/1/2023,5/8/2023,5/15/2023,5/22/2023,5/29/2023,6/1/2023,6/5/2023,6/12/2023,6/19/2023,6/26/2023,7/1/2023,7/10/2022,7/17/2022,7/24/2022,7/31/2022,8/1/2023,8/7/2023,8/14/2023,8/21/2023,8/28/2023,9/1/2023,9/4/2023,9/11/2023,9/18/2023,9/25/2023,10/1/2023,10/9/2023,10/16/2023,10/23/2023,10/30/2023,11/1/2023,11/6/2023,11/13/2023,11/20/2023,11/27/2023,12/1/4/2023,12/4/2023,12/11/2023,12/18/2023,12/25/2023,1/1/2024,1/8/2024,1/15/2024,1/22/2024,1/29/2024,2/1/2024,2/5/2024,2/12/2024,2/19/2024,2/26/2024,3/1/2024,3/4/2024,3/11/2024,3/18/2024,3/25/2024
Code:
Parse Delimited String
VA rpt_FlatFileRecord_FFRC -> BF szInputObjectID
VA rpt_Date_Column19_CFSTR5 <- BF szOutputObjectSegment
"19.00" -> BF mnSegmentNumber
"," -> BF cDelimiter
Parse Delimited String
VA rpt_FlatFileRecord_FFRC -> BF szInputObjectID
VA rpt_Date_Column20_CFSTR5 <- BF szOutputObjectSegment
20.00" -> BF mnSegmentNumber
"," -> BF cDelimiter
Parse Delimited String
VA rpt_FlatFileRecord_FFRC -> BF szInputObjectID
VA rpt_Date_Column21_CFSTR5 <- BF szOutputObjectSegment
"21.00" -> BF mnSegmentNumber
"," -> BF cDelimiter
Values populated:
VA rpt_Date_Column19_CFSTR5 = "6/26/2023"
VA rpt_Date_Column20_CFSTR5 = "7/1/202"
VA rpt_Date_Column21_CFSTR5 = null
Why is it happening??
I would appreciate any help you could provide.
I am using B98220D Parse Delimited String to load values from the CSV table into variables. I can see that the input record is complete, I have 66 columns, comma delimited.
However, I can see in the debug that on column 20, values stop coming through.
VA rpt_FlatFileRecord_FFRC Input string (verified in the debug that it is complete) looks like this:
,3/1/2023,3/6/2023,3/13/2023,3/20/2023,3/27/2023,4/1/2023,4/3/2023,4/10/2023,4/17/2023,4/24/2023,5/1/2023,5/8/2023,5/15/2023,5/22/2023,5/29/2023,6/1/2023,6/5/2023,6/12/2023,6/19/2023,6/26/2023,7/1/2023,7/10/2022,7/17/2022,7/24/2022,7/31/2022,8/1/2023,8/7/2023,8/14/2023,8/21/2023,8/28/2023,9/1/2023,9/4/2023,9/11/2023,9/18/2023,9/25/2023,10/1/2023,10/9/2023,10/16/2023,10/23/2023,10/30/2023,11/1/2023,11/6/2023,11/13/2023,11/20/2023,11/27/2023,12/1/4/2023,12/4/2023,12/11/2023,12/18/2023,12/25/2023,1/1/2024,1/8/2024,1/15/2024,1/22/2024,1/29/2024,2/1/2024,2/5/2024,2/12/2024,2/19/2024,2/26/2024,3/1/2024,3/4/2024,3/11/2024,3/18/2024,3/25/2024
Code:
Parse Delimited String
VA rpt_FlatFileRecord_FFRC -> BF szInputObjectID
VA rpt_Date_Column19_CFSTR5 <- BF szOutputObjectSegment
"19.00" -> BF mnSegmentNumber
"," -> BF cDelimiter
Parse Delimited String
VA rpt_FlatFileRecord_FFRC -> BF szInputObjectID
VA rpt_Date_Column20_CFSTR5 <- BF szOutputObjectSegment
20.00" -> BF mnSegmentNumber
"," -> BF cDelimiter
Parse Delimited String
VA rpt_FlatFileRecord_FFRC -> BF szInputObjectID
VA rpt_Date_Column21_CFSTR5 <- BF szOutputObjectSegment
"21.00" -> BF mnSegmentNumber
"," -> BF cDelimiter
Values populated:
VA rpt_Date_Column19_CFSTR5 = "6/26/2023"
VA rpt_Date_Column20_CFSTR5 = "7/1/202"
VA rpt_Date_Column21_CFSTR5 = null
Why is it happening??
I would appreciate any help you could provide.