Starts with write line

Help
,
1

Hello,

i need a help for the below
code qty ID
212345 anything 100
14565 kg 1
14564 no 2

image

if code starts with 2 qty anything that ID should be 100
if code starts with 1 and qty is kg ID should be 1
if code starts with 1 and qty is no ID should be 2

Thanks in advance

2

@Shriharsha_H_N,

Where you want to modify/write like that?

3

Fine
hope this steps would help you resolve this
–use a excel application scope and pass the file pathas input
–inside the scope use a READ range activty and get the output with a variable of type datatable namedd dt
–now use a for each row loop and pass the input as dt
–inside the loop use a assign activity
row(2) = if(row(0).ToString.StartsWith(“2”),row(2) = “100”, IF(row(0).ToString.StartsWith(“1”) and row(0).ToString.Equals(“kg”),row(2) = “1”,row(2) = “2”),string.empty)

Cheers @Shriharsha_H_N

1 Like
4

@sarathi125 in the write line/message box

5

we can use the above expression in side the for each row loop within writeline activity
Cheers @Shriharsha_H_N

1 Like
6

image

just follow the same for the rest of the conditions.

7

@Palaniyappan its throwing a error please look into the screenshot
image

8

remove these row(4) = and keep just the values like “100” “1” “2”
as we are using aassign activity here
image

Cheers @Shriharsha_H_N

9

@Palaniyappan

image
image700×275 8.39 KB

1 Like
10

the expression will be like this
if(row(0).ToString.StartsWith(“2”),“100”, IF(row(0).ToString.StartsWith(“1”) AND row(0).ToString.ToUpper.Equals(“KG”),“1”,“2”),string.empty)

Cheers @Shriharsha_H_N

11

No same error

1 Like
12

aah got it
remove the string.empty
if(row(0).ToString.StartsWith(“2”),“100”, IF(row(0).ToString.StartsWith(“1”) AND row(0).ToString.ToUpper.Equals(“KG”),“1”,“2”))

sorry for that
Cheers @Shriharsha_H_N

13

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