Skip to main content
A
Anonymous
June 15, 2020

Does anyone have a Parse Rule or another method of getting just the current month to import.

  • June 15, 2020
  • 1 reply
  • 0 views
Originally posted by Craig Masters

12/3/2018

Data Source Parser Question: Client's data file contains 12 columns for the months no matter when it is run for the year. If it's January, it will have 12 columns showing Jan - Dec. Does anyone have a Parse Rule or another method of getting just the current month to import. 

 

1 reply

A
Anonymous
June 26, 2020
Originally posted by Joakim Kulan

I managed to optimize the code:

Dim povPeriod As String = TimeDimHelper.GetNameFromId(api.WorkflowUnitPk.TimeKey)
Dim colNo As Integer = povPeriod.Split(""M"")(1).XFConvertToInt + 3

Return api.Parser.DelimitedParsedValues(colNo)

Terms & ConditionsAccessibility statement