Substring in between special characters

[lmit]

Hi All,

I have below in put data

1 DF abc xyz

I want my output as below

DF

i tried substring method but couldn't get correct results. can anyone help me with the solution

Thanks in advance,

lmit

[Anonymous · Accepted solution]

Hello lmit,

please try the below solutions:

column.substring(2,4)

or

column.split(" ")[1]

Best regards

Aiming

[lmit]

thanks @Aiming Chen​