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.
|
¡Resuelto! Ir a solución.
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.
Hi @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
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