Incorrect Values in Excel-URGENT

Hi @Nithinkrishna @ermanoj3101
While using string manipulation i’m getting junk value in excel for particular column.
PFBSS of string in code.


The value getting in excel :-1:
image
Value trying to get from pdf
image

1 Like

Hi @mitul_choudhary

You need to use string.join method to join array values your required value!

String.Join(" ",exchange2)

Regards

1 Like

Hey @mitul_choudhary

It is not a junk value instead you are just passing an array into the excel.

Just check your split commands in multiple assign is it fine…

As I remember you were saying all variables should be string…

Thanks
#nK

1 Like

Thanks @Nithinkrishna @pravin_calvin can u pls help me do that pls find below string i want value { “1”, “”, “USD”, “INR”, “”, “75.35” } but it’s coming image

Split(Split(Split(IEC1,“9.EXCHANGE RATE”)(1).Trim,vbNewline)(1).Trim.Remove(0,24))

1 Like

Could you please show how are you writing back to excel.

Thanks
#nK

1 Like

using add data row & write range.

1 Like

here, just replace exchangerate2 with the statement suggested by @pravin_calvin

String.Join(" ",exchange2)

Thanks
#nK

1 Like

Where shall i replace in multiple assign or add data row(where i’m passing variable.)

Please find below string :-
Split(Split(Split(IEC1,“9.EXCHANGE RATE”)(1).Trim,vbNewline)(1).Trim.Remove(0,24))

1 Like

Please dont touch the multi assign, just do the change in add data row.

Thanks
#nK

1 Like

1 Like

Hi @mitul_choudhary

Instead of exchangerate2 in add data row replace by

string.join(" ",exchangerate2)

Regards

1 Like

@mitul_choudhary

yes !

1 Like

@Nithinkrishna @pravin_calvin
This is giving same output.
image

But while checking on immediate it’s coming required value, just wanna know where to pass it.
image

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.