Fields reference in a Connector Datasrc

[aprats]

Hi all, 

I need to assign a value in a field, dependeing on an other. I can do it in Delimited Files using  "api.Parser.DelimitedParsedValues()" but I don't know wich function can provide me the string of an other field.

So, in conclusion: how can I do this in a Connector Complex expression?

Thanks!

[ckattookaran]

Use args.line and use split operation.

args.line.split(",")(1)

[aprats]

Thank you so much for your help.

I have a doubt: how the system know the field that I need?

This are my list of fields:

My args is INTERCO. I need to evaluate the OBJ field and depending on this, assign an INTERCO value.

If I use args.line.split(",")(1) I'm referencing the fist field from my list?

Thank you very much!

[ckattookaran]

That is a zero-indexed item, so in your case it is 3

[SWilyums]

Celvin, any options for parsing where the field values have commas? Can I call a column based on the column name from a complex expression where the data is coming through using a connector rule?

[ckattookaran · Accepted solution]

If you are using multiple fields then I would do it as 

Dim fieldValues as String() = args.line.split(",")

Then fieldValues(0) is first column and filed values(3) is 4th column. 

[aprats]

Thanks! It works absolutly fine.