Assign Activity Error--URGENT

[mitul_choudhary]

Hi @Nithinkrishna @ermanoj3101
I’m facing this issue while i’m using string manipulation in multiple assign activity.
Agenda was to fetch value from pdf to excel.

[Nithinkrishna]

Could you please show the full error message ?

[mitul_choudhary]

This i got while debugging…!!

[Nithinkrishna]

Great you are trying to assign a string Array value to string. You need to keep your variable type as stringArray please !

[mitul_choudhary]

How will i identify the value which one are stringArray…?

[Nithinkrishna]

It seems all the values are string Array which you are trying to use in multiple assign.

Which is clearly displayed in error message and you can even check in the code.

[mitul_choudhary]

Please find below the string’s i’m using, all are assigned in multiple assign activity with some variable.
Split(Split(Split(IEC1,“1.S.No”)(1).Trim,vbNewline)(2).Trim)(0)------s.NO
Split(Split(Split(IEC1,“6.AD code”)(1).Trim,vbNewline)(2).Trim)(3)-----------Ad code
Split(Split(Split(IEC1,“6.AD code”)(1).Trim,vbNewline)(2).Trim)(4)-----------interin
Split(Split(Split(IEC1,“1.EXPORTER’S NAME & ADDRESS”)(1).Trim,vbNewline)(1).Trim.Remove(19))--------------Exports name
Split(Split(Split(IEC1,“2.BUYER’S NAME & ADDRESS”)(1).Trim,vbNewline)(1).Trim.Remove(0,20))----------Buyers name&add
Split(Split(Split(IEC1,“1.INVOICE VALUE”)(1).Trim,vbNewline)(2).Trim)(0)-----Invoice value
Split(Split(Split(IEC1,“2.FOB VALUE”)(1).Trim,vbNewline)(2).Trim)(1)-----------FOB value
Split(Split(Split(IEC1,“3FREIGHT”)(1).Trim,vbNewline)(2).Trim)(2)
Split(Split(Split(IEC1,“4.INSURANCE”)(1).Trim,vbNewline)(2).Trim)(3)
Split(Split(Split(IEC1,“5DISCOUNT”)(1).Trim,vbNewline)(2).Trim)(4)
Split(Split(Split(IEC1,“5DISCOUNT”)(1).Trim,vbNewline)(3).Trim)(4)--------seperate USD
Split(Split(Split(IEC1,“6.COMMISON”)(1).Trim,vbNewline)(2).Trim)(5)
Split(Split(Split(IEC1,“7.DEDUCT”)(1).Trim,vbNewline)(2).Trim)(6)
Split(Split(Split(IEC1,“7.DEDUCT”)(1).Trim,vbNewline)(2).Trim)(6)+Environment.NewLine+“USD”
Split(Split(Split(IEC1,“8.P/C”)(1).Trim,vbNewline)(2).Trim)(7)
Split(Split(Split(IEC1,“9.EXCHANGE RATE”)(1).Trim,vbNewline)(1).Trim.Remove(0,24))
Split(Split(Split(IEC1,“1.ItemSNo”)(1).Trim,vbNewline)(1).Trim)(0)
Split(Split(Split(IEC1,“2.HS CD”)(1).Trim,vbNewline)(1).Trim)(1)

Split(Split(Split(IEC1,“4.QUANTITY”)(1).Trim,vbNewline)(1).Trim)(11)
Split(Split(Split(IEC1,“5.UQC”)(1).Trim,vbNewline)(1).Trim)(12)
Split(Split(Split(IEC1,“6.RATE”)(1).Trim,vbNewline)(1).Trim)(13)
Split(Split(Split(IEC1,“6.RATE”)(1).Trim,vbNewline)(1).Trim)(14)

[Nithinkrishna]

Could you please share the snap of activity

[mitul_choudhary]

PFB the snap of pdf as well.

[Nithinkrishna]

There are some three values in assign which is somehow mistyped as an array.

You need to rectify that checking whether the split function is right …