How do I copy the text?

Perawat · August 24, 2020, 6:30am

Hello everyone,
I’m want to copy the previous line of text to put the blank line.
I have the following information. test.xlsx (9.6 KB)

Thanks.
Perawat

Pradeep_Shiv · August 24, 2020, 6:38am

You can go through this post

monsieurrahul · August 24, 2020, 7:08am

You can achieve this using a for each loop. Kindly follow the below steps:

Read the Input Excel and store the result in a DT.
Use a For Each Row activity and iterate through the DT.
Create a local variable, say “Temp” and store the value of row(“Bill No”) in it.
Check if the variable returns an empty string using String.IsNullOrEmpty() function.
If it does, assign the value of the “Temp” variable to the row(“Bill No”) inside the ‘then’ block.

Try this and let me know if you are still facing any issues.

Cheers!

Perawat · August 24, 2020, 9:46am

@monsieurrahul, Could you please write a workflow for me ?

ppr · August 24, 2020, 10:14am

@Perawat
find some starter help here:
FillUp_BlockBlanks.xaml (8.7 KB)

monsieurrahul · August 24, 2020, 11:00am

@Perawat Here you go:

system · August 27, 2020, 11:00am

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