Data type for combination of text and numbers

Help Activities
, ,
1

Hello everyone. What should be the data type for combination of text and numbers? Thanks

1 Like
2

Hi,

In general, it will be String type.

Regards,

3

Hello. For instance, I am trying to get this column in the excel file using Get Row Item Activity

Code
43234
12312
12312
12412

then placed it in a variable named chargeCodes, what should be the data type of chargeCodes? I tried to use String but it says that “Get Row Item: StringConverter cannot convert from System.Double.”

Do you know what to do?

4

Hi,

in this case, can you try GenericValue(UiPath.Core.GenericValue) type? Then convert to String type using ToString method, if necessary.

Regards,

1 Like
5

Do i need to download a package for that type? when i tried to input that in the search bar, nothing shows…

6

oh wait. i saw it

7

it worked!! thank you so much!!

1 Like
8

Can I ask you a question regarding HTML? That is if it’s okay with you

9

Hi,

Do you mean the following topic?

Can you elaborate output you expect?

Regards,

10

yepp, that is the one!! My expected output is that the Employee Country/Region will be displayed in the next column because I am using html tag. Then same goes with Expense type. I am not sure if it is visible but I tried to use and

11

tried to use tr and td*

12

Hi,

alright. I’ll reply in the topic.

Regards,

13

This is totally unnecessary. The variable can just be a string, no conversion necessary.

14

Hi @postwick ,

There are some cases to need to use GenericValue type , as the following, for example.
Then, use ToString method to make sure conversion to String.

img20210507-1
img20210507-11888Ă—858 57.6 KB

Can you check the following simple sample?

Regards,

15

Why would you need to use generic value there? If you’re getting a number, the variable should be an integer or double. If you’re getting a string, it should be string. In your example, you’re trying to put a double into a string value. If you want that value in a string, use an Assign (instead of Get Row Item) and use CurrentRow.Item(0).ToString

I never use those activities like Get Row Item. It’s much better to just do an Assign and be specific.

In fact, the point to Generic Values is that you don’t have to explicitly convert them.

1 Like
16

Hi @postwick ,

Basically, you’re right. However, in some cases, Studio dosen’t accept it , as the following, for example. Although it might be depended on environment (such as version), I suggested to use ToString to makes sure conversion.

img20210507-2
img20210507-21178Ă—402 30.4 KB

Can you check the following xaml?

Sequence.xaml (8.7 KB)

Regards,

17

It’s always better to use proper datatypes and be specific in your code. Makes it easier to understand what’s happening, find errors, etc.

18

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