Incorrect Values in Excel-URGENT

Help Studio
, ,
1

Hi @Nithinkrishna @ermanoj3101
While using string manipulation i’m getting junk value in excel for particular column.
PFBSS of string in code.
image
The value getting in excel :-1:
image
Value trying to get from pdf
image

1 Like
2

Hi @mitul_choudhary

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

String.Join(" ",exchange2)

Regards

1 Like
3

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
4

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
5

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

Thanks
#nK

1 Like
6

using add data row & write range.

image
image1207×223 12.1 KB

1 Like
7

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

String.Join(" ",exchange2)

Thanks
#nK

1 Like
8

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
9

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

Thanks
#nK

1 Like
10

image
image1209×212 11.4 KB

1 Like
11

Hi @mitul_choudhary

Instead of exchangerate2 in add data row replace by

string.join(" ",exchangerate2)

Regards

1 Like
12

@mitul_choudhary

yes !

1 Like
13

@Nithinkrishna @pravin_calvin
This is giving same output.

image
image164×137 1.29 KB

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

image
image459×426 8.38 KB

14

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