Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
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 hav...
Data Sources
OSAdmin's avatar
OSAdmin
Valued Contributor II
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)