How to get desired number of characters from excel to string. it should be dynamic.?

Help
, , ,
1

How to get only desired number of characters from excel to string. it should be dynamic.?

Test%20with%20error
Test%20with%20error1195×862 22 KB

2

Hi
we can use substring method like htis
yourstringvariable.ToString.SubString(starting index of character, number of characters need)
where starting index sttarts from 0 for first character
for example
str_input = “abcdef”
str_input = str_input.ToString.SubString(0,3)
the output will be “abc”

Cheers @rahul_gola

2 Likes
3

Hi thank you for your help palaniyappan,

but i am getting an error. ss attached

error
error1451×598 21.3 KB

1 Like
4

fine may i know what is the actual length of that string
to find that
yourvariable.Length.ToString
kindly find that and mention the number of characters to retrieved

Cheers @rahul_gola

5

yes the length of the string is 26, but i want it to be dynamic
ex: in fist field it cannot be more then 128
in 2nd field it cannot be more then 20
but i want what so ever is there till 20 to be in the field.
and in 3rd it should not be more then 12.

i have tried the above but no luck

1 Like
6

can i have an example of input and how many characters you need from each column
Cheers @rahul_gola

7

i have attached an ss for you reference,
i want that text from excel to be filed into another column, there i have restriction in the first filed where the length limit is only 128,
in 2nd column i have a limit of 50 characters,
and in 3rd limit reduced to 12.

Capture
Capture772×484 25.4 KB
title

1 Like
8

ok got it
so the expression be like this in the type into activity

for first column
str_input.ToString.SubString(0,IF(str_input.ToString.Length<128,str_input.ToString.Length,128)

for second column
str_input.ToString.SubString(0,IF(str_input.ToString.Length<50,str_input.ToString.Length,50)

for third column
str_input.ToString.SubString(0,IF(str_input.ToString.Length<12,str_input.ToString.Length,12)

Cheers @rahul_gola

2 Likes
9

Thank you,

i am having an error ss attached.

error%202
error%2021133×582 23.9 KB

1 Like
10

str_input.ToString.SubString(0,(if (str_input.Length<128,str_input.length,128)))

11

sorry buddy
that was a typo mistake
str_input.ToString.SubString(0,IF(str_input.ToString.Length<128,str_input.ToString.Length,128)

for second column
str_input.ToString.SubString(0,IF(str_input.ToString.Length<50,str_input.ToString.Length,50)

for third column
str_input.ToString.SubString(0,IF(str_input.ToString.Length<12,str_input.ToString.Length,12)

Cheers @rahul_gola

1 Like
12

is this working
kindly let know for any queries or clarification
Cheers @rahul_gola

1 Like
13

Hi so sorry to reply late was busy in the further development. kinda urgent.

yes it is working great… thanks a lot for your help Palaniyappan :slight_smile:

14

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