08-29-2022 05:50 AM
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!
Solved! Go to Solution.
08-29-2022 02:10 PM
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.
08-29-2022 12:17 PM
Use args.line and use split operation.
args.line.split(",")(1)
08-29-2022 12:44 PM
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!
08-29-2022 02:07 PM
That is a zero-indexed item, so in your case it is 3
11-30-2022 05:14 PM
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?
08-29-2022 02:10 PM
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.
08-30-2022 03:26 AM
Thanks! It works absolutly fine.