Split Text to Column - Get First 5 digits

Help Activities
, ,
1

Hi,

I would like to split the data in column ‘Text’ by using comma and get only the first 5 number of the text. Can anyone help me on this. Your help will be much appreciated.

Before:
image

After:
image
Test.xlsx (13.7 KB)

2

Hi,

Hope the following helps you.

img20210330-1
img20210330-11189×816 43.8 KB

Sample20210330-1.zip (22.5 KB)

Regards,

2 Likes
3

Thank you so much for your fast response. I got what I needed.

1 Like
4

Hi @jenkim
I see the topic is already resolved, I solved it as well so sharing just in case.Main.xaml (12.8 KB)

image
image425×602 18.5 KB

Last assign is: arr_Text(0).ToString.Substring(0,5)

1 Like
5

Thank you so much for your help. I’m able to learn more about this. :smiley:

6

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