Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ID | Lable |
1 | dfdfd,Sprint1,dgd |
2 | Sprint1 |
3 | fdfdg,gdgfg,ghfhfh,Sprint1 |
4 | fsfsdf,Sprint2 |
5 | Sprint2 |
6 | dfd,3434,gdg434,Sprint1,egrrg,555 |
I have above data set in excel. i want to find the the word 'Sprint%' in the column Lable and store the value (like Sprint1,Sprint2) in a separate column call Sprint when loading that excel. is it possible.
use function mid:
=mid(Lable,FindOneOf(Lable,'Sprint%'),7) - works if Sprintx has only values 0--9
if your number after Sprint contain more than 1 Digit you Need to find the right comma after Sprint to get the correct lenght (instead 7)
here when there is a text startng with S then it is also consider as 'Sprint%' when we use finfoneof
Hi,
maybe splitting the substrings in Lable field would make it a bit easier.
Meets the following script your requirements:
TEST:
LOAD * INLINE [
ID, Lable
1, "dfdfd,Sprint1,dgd"
2, "Sprint1"
3, "fdfdg,gdgfg,ghfhfh,Sprint1"
4, "fsfsdf,Sprint2"
5, "Sprint2"
6, "dfd,3434,gdg434,Sprint1,egrrg,555"
];
NEU:
LOAD * where SUB_LABLES like 'Sprint*';
LOAD
*,
subfield(Lable,',') as SUB_LABLES
resident TEST;
Regards,
Tobias