Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I got stuck at one point. I've tried number of logic's but didn't succeed.
@sunny_talwar @swuehl @kaushiknsolanki
Here is my requirement:
This is the Data:
LOAD * INLINE [
String, Number
Gordon/JayHanbey, 1/2
JimScott/Hardy, 2/1
Gemma, 1
JohnSmith, 2
Ryan/AlexWhite/SeanWilliams, 1/2/3
];
Regards,
Nol
One Solution is:
tab1:
LOAD *, SubField(String&'/','/',IterNo()) As Str,
SubField(Number&'/','/',IterNo()) As Num, SubStringCount(String,'/') As Cnt
While IterNo()<=SubStringCount(String&'/','/')
;
LOAD * INLINE [
String, Number
Gordon/JayHanbey, 1/2
JimScott/Hardy, 2/1
Gemma, 1
JohnSmith, 2
Ryan/AlexWhite/SeanWilliams, 1/2/3
];
One Solution is:
tab1:
LOAD *, SubField(String&'/','/',IterNo()) As Str,
SubField(Number&'/','/',IterNo()) As Num, SubStringCount(String,'/') As Cnt
While IterNo()<=SubStringCount(String&'/','/')
;
LOAD * INLINE [
String, Number
Gordon/JayHanbey, 1/2
JimScott/Hardy, 2/1
Gemma, 1
JohnSmith, 2
Ryan/AlexWhite/SeanWilliams, 1/2/3
];
Hi Saran,
This is what I need. Wow, what an amazing solution.
Short, sweet & perfect.
Thanks for putting your time & efforts into my issue.
Many Thanks.
Regards,
Nol
you welcome