Trim integer value

Help
1

Hi All,

I got a list of integer in a specific column,

I have loop each integer, and now my question is how to trim each list of integer into value that i wanted.

For example:

this is one of integer value: C121000.00000.000.000.71432000.000.00
how to trim it to get this value only: 71432000

Thank you so much

2

Hi @mashy2

Splitting the value by “.” Would get it. But i have one question. In that long value would that place will always be the location for the value you want? Or does the location of the value change

3

To use split you can try below

StrVariable.Split("."c)(4).ToString

This will return the value you need.

4

Hi @Lahiru.Fernando
Location of the value will always be the same
Thank you very much!

5

Then you can use this without a problem :slight_smile:

If this works for you, please mark the answer as the solution too :slight_smile:

3 Likes
6

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