https://community.qlik.com/t5/Talend-Studio/How-to-translate-a-string-containing-multiple-lines-into-a-flow/m-p/2350026#M116928 <P>Hello , </P><P>Maybe it's not the best way but i designed my job as such </P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000G63TMAAZ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157399i73B851E686BDF758/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000G63TMAAZ.png" alt="0695b00000G63TMAAZ.png" /></span>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000G63RwAAJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129597i445657E6F5445B79/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000G63RwAAJ.png" alt="0695b00000G63RwAAJ.png" /></span>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000G63U5AAJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138707iBCBE640720F78E6B/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000G63U5AAJ.png" alt="0695b00000G63U5AAJ.png" /></span>&nbsp;</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000G63UAAAZ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/145087i8CB954BB4C4A7564/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000G63UAAAZ.png" alt="0695b00000G63UAAAZ.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="0695b00000G63UUAAZ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133166i7951CD9786149535/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000G63UUAAZ.png" alt="0695b00000G63UUAAZ.png" /></span>&nbsp;</P><P>In the tmap here is the regex row3.s.trim().matches("^[0-9]*$") </P><P>&nbsp;</P><P>Output would be : </P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000G63WBAAZ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132805iF83BA5AC14406B48/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000G63WBAAZ.png" alt="0695b00000G63WBAAZ.png" /></span>Regards , </P><P>Amine </P> Tue, 22 Jun 2021 11:45:54 GMT kakooo16 2021-06-22T11:45:54Z https://community.qlik.com/t5/Talend-Studio/How-to-translate-a-string-containing-multiple-lines-into-a-flow/m-p/2350025#M116927 <P>Hi, All!</P><P>I have a string in tJavaRow </P><P>String S = "10;Str;\n20;Str2;</P><P>\n30;Str3</P>";<P>How can I convert it into a Flow (get 3 lines at the output </P><P>10|Str1|</P><P></P><P>20|Str2|</P><P></P><P>30|Str3|</P><P>) ?</P> Sat, 16 Nov 2024 00:01:25 GMT https://community.qlik.com/t5/Talend-Studio/How-to-translate-a-string-containing-multiple-lines-into-a-flow/m-p/2350025#M116927 Igor_V 2024-11-16T00:01:25Z https://community.qlik.com/t5/Talend-Studio/How-to-translate-a-string-containing-multiple-lines-into-a-flow/m-p/2350026#M116928 <P>Hello , </P><P>Maybe it's not the best way but i designed my job as such </P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000G63TMAAZ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157399i73B851E686BDF758/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000G63TMAAZ.png" alt="0695b00000G63TMAAZ.png" /></span>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000G63RwAAJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129597i445657E6F5445B79/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000G63RwAAJ.png" alt="0695b00000G63RwAAJ.png" /></span>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000G63U5AAJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138707iBCBE640720F78E6B/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000G63U5AAJ.png" alt="0695b00000G63U5AAJ.png" /></span>&nbsp;</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000G63UAAAZ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/145087i8CB954BB4C4A7564/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000G63UAAAZ.png" alt="0695b00000G63UAAAZ.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="0695b00000G63UUAAZ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133166i7951CD9786149535/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000G63UUAAZ.png" alt="0695b00000G63UUAAZ.png" /></span>&nbsp;</P><P>In the tmap here is the regex row3.s.trim().matches("^[0-9]*$") </P><P>&nbsp;</P><P>Output would be : </P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000G63WBAAZ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132805iF83BA5AC14406B48/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000G63WBAAZ.png" alt="0695b00000G63WBAAZ.png" /></span>Regards , </P><P>Amine </P> Tue, 22 Jun 2021 11:45:54 GMT https://community.qlik.com/t5/Talend-Studio/How-to-translate-a-string-containing-multiple-lines-into-a-flow/m-p/2350026#M116928 kakooo16 2021-06-22T11:45:54Z https://community.qlik.com/t5/Talend-Studio/How-to-translate-a-string-containing-multiple-lines-into-a-flow/m-p/2350027#M116929 <P>Hi, a better regex : "^\\d+$"</P><P>Send me Love and Kudos</P> Tue, 22 Jun 2021 12:14:11 GMT https://community.qlik.com/t5/Talend-Studio/How-to-translate-a-string-containing-multiple-lines-into-a-flow/m-p/2350027#M116929 gjeremy1617088143 2021-06-22T12:14:11Z