Remove characters and special characters

[debmsarkar123]

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

[Taoufiq_Zarra]

@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:

[MayilVahanan]

Hi

Try like below

TextBetween(Weeks 'W', '(')

Ex: TextBetween('W31(31.07)', 'W', '(') gives 31