Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field like this-
Weeks
W31(31.07)
W32(07.08)
How do i remove the special characters and text and just keep the two numbers after W so that the new field becomes-
Weeks
31
32
@debmsarkar123 Maye be like :
Mid(Weeks,index(Weeks,'W')+1,2)
for exemple :
Input:
LOAD *,Mid(Weeks,index(Weeks,'W')+1,2) as New_Weeks INLINE [
Weeks
W31(31.07)
W32(07.08)
];
output:
Hi
Try like below
TextBetween(Weeks 'W', '(')
Ex: TextBetween('W31(31.07)', 'W', '(') gives 31