Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago

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

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. 

 

Data Sources
  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    5 years ago
    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)