Hi there, Could anyone help me to implement a workflow which takes below input and produce certain output which is also mentioned below. Input:- RecordID Value 1 1. Abcdef 2 This is first dummy text line 3 this is second dummy text line. 4 This is third dummy text line. 5 2. Xyz 6 This is first dummy introduction line, 7 this is second dummy introduction line 8 this is third dummy introduction line 9 this is fourth dummy introduction line. 10 3. Pqrst 11 This is dummy text line 12 this is another dummy text line. Output required:- RecordID Value1 Value2 1 1. Abcdef This is first dummy text line this is second dummy text line. This is third dummy text line. 2 2. Xyz This is first dummy introduction line, this is second dummy introduction line this is third dummy introduction line this is fourth dummy introduction line. 3 3. Pqrst This is dummy text line this is another dummy text line.

Split the rows and columns as mentioned below and also append the text.

Hi there,

Could anyone help me to implement a workflow which takes below input and produce certain output which is also mentioned below.

Input:-

RecordID	Value
1	1. Abcdef
2	This is first dummy text line
3	this is second dummy text line.
4	This is third dummy text line.
5	2. Xyz
6	This is first dummy introduction line,
7	this is second dummy introduction line
8	this is third dummy introduction line
9	this is fourth dummy introduction line.
10	3. Pqrst
11	This is dummy text line
12	this is another dummy text line.

Output required:-

RecordID	Value1	Value2
1	1. Abcdef	This is first dummy text line this is second dummy text line. This is third dummy text line.
2	2. Xyz	This is first dummy introduction line, this is second dummy introduction line this is third dummy introduction line this is fourth dummy introduction line.
3	3. Pqrst	This is dummy text line this is another dummy text line.

Developer

Accepted answers

Sebastiaandb

Hi @Mohd-Siddiqui1 !

Here you go!

It doesn't matter. All the function does is check whether the first character is a number or not :-)! If so, it takes the value for the flag field. All rows after that get the same flag until it finds another row starting with a number value :-).

Greetings,

Seb

Splittherowsandcolumns.yxmd

All comments

Sebastiaandb

Hi @Mohd-Siddiqui1 ,

Here you go!

Let me know if this works for you!

Greetings,

Seb

Splittherowsandcolumns.yxzp

Christina_H

Here you go. I added some numbers to one row of your data to make sure I was correctly picking up numbers from the start of a row only. I've used that to identify the start of each group and the row to separate from the group - it won't work if there are other rows that start with numbers, you would need a different way to identify the right ones.

Concatenate.yxmd

Mohd-Siddiqui1

Sebastiaandb,

Thanks for your quick response.

Could you please provide the workflow in .yxmd extension, as I am facing problem in opening .yxzp file.

From the image I could see IsInteger(Left([Value], 1)) in formula tool, where 1 is the length (i guess), but what if the length of integer is more for e.g. :- 17. Abcdefghi

Thanks

Sebastiaandb

Hi @Mohd-Siddiqui1 !

Here you go!

Greetings,

Seb

Splittherowsandcolumns.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703