Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
6 years ago
Solved

Odd Data Source

Originally posted by Andrea Tout 7/10/2019 I have an odd data source if someone can help me. The Data Source works that the second to last column has the data, and the last column has a "cr" if i...
Data Sources
  • OSAdmin's avatar
    OSAdmin
    6 years ago
    Originally posted by Joakim Kulan

    That was it! Here it the final product:
    Dim secondarCol As String = api.Parser.DelimitedParsedValues(8).Replace(""$"",String.Empty)

     

    If api.parser.delimitedparsedvalues.count > 9 Then
    Return secondarCol.XFConvertToDecimal *-1
    Else
    Return secondarCol.XFConvertToDecimal
    End If

OSAdmin's avatar
OSAdmin
Valued Contributor II
6 years ago
Originally posted by Joakim Kulan

That was it! Here it the final product:
Dim secondarCol As String = api.Parser.DelimitedParsedValues(8).Replace(""$"",String.Empty)

 

If api.parser.delimitedparsedvalues.count > 9 Then
Return secondarCol.XFConvertToDecimal *-1
Else
Return secondarCol.XFConvertToDecimal
End If