https://community.qlik.com/t5/Talend-Studio/Substring-in-between-special-characters/m-p/2319638#M89859 <P>Hello lmit,</P><P>please try the below solutions:</P><P>column.substring(2,4)</P><P>or</P><P>column.split(" ")[1]</P><P>&nbsp;</P><P>Best regards</P><P>Aiming</P> Mon, 29 Aug 2022 01:01:19 GMT Anonymous 2022-08-29T01:01:19Z https://community.qlik.com/t5/Talend-Studio/Substring-in-between-special-characters/m-p/2319637#M89858 <P>Hi All,</P><P></P><P></P><P>I have below in put data</P><P></P><P></P><P>1 DF abc xyz</P><P></P><P></P><P>I want my output as below</P><P>DF</P><P></P><P></P><P>i tried substring method but couldn't get correct results. can anyone help me with the solution</P><P></P><P></P><P>Thanks in advance,</P><P>lmit</P> Sun, 28 Aug 2022 14:08:10 GMT https://community.qlik.com/t5/Talend-Studio/Substring-in-between-special-characters/m-p/2319637#M89858 lmit 2022-08-28T14:08:10Z https://community.qlik.com/t5/Talend-Studio/Substring-in-between-special-characters/m-p/2319638#M89859 <P>Hello lmit,</P><P>please try the below solutions:</P><P>column.substring(2,4)</P><P>or</P><P>column.split(" ")[1]</P><P>&nbsp;</P><P>Best regards</P><P>Aiming</P> Mon, 29 Aug 2022 01:01:19 GMT https://community.qlik.com/t5/Talend-Studio/Substring-in-between-special-characters/m-p/2319638#M89859 Anonymous 2022-08-29T01:01:19Z https://community.qlik.com/t5/Talend-Studio/Substring-in-between-special-characters/m-p/2319639#M89860 <P>thanks @Aiming Chen​&nbsp;</P> Mon, 29 Aug 2022 10:50:39 GMT https://community.qlik.com/t5/Talend-Studio/Substring-in-between-special-characters/m-p/2319639#M89860 lmit 2022-08-29T10:50:39Z