Hi I have a dataset where I have check if the last value meets below criteria I have to put it in a new column
Input:
F1 |
1.00,ABC,456,74589EXB9 |
1.67,0.00 |
1.45,EUR |
,,,, |
1.23,567,987521EX0 |
516,AEV,1.23 |
Condition:
1. Last value should not be in decimal
2. last value is length should be greater than 3
4. If all above condition I have to copy the id and paste it below till I get a new ID
Output:
F1 | ID |
1.00,ABC,456,74589EXB9 | 74589EXB9 |
1.67,0.00 | 74589EXB9 |
1.45,EUR | 74589EXB9 |
,,,, | 74589EXB9 |
1.23,567,987521EX0 | 987521EX0 |
516,AEV,1.23 | 987521EX0 |
So first row meet the condition, So pasted in the ID column till I get a new ID from F1 column