Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Igor_V
Contributor
Contributor

How to translate a string containing multiple lines into a flow.

Hi, All!

I have a string in tJavaRow

String S = "10;Str;\n20;Str2;

\n30;Str3

";

How can I convert it into a Flow (get 3 lines at the output

10|Str1|

20|Str2|

30|Str3|

) ?

Labels (3)
2 Replies
kakooo16
Creator
Creator

Hello ,

Maybe it's not the best way but i designed my job as such

 

0695b00000G63TMAAZ.png 

 

0695b00000G63RwAAJ.png 

 

 

0695b00000G63U5AAJ.png 

0695b00000G63UAAAZ.png0695b00000G63UUAAZ.png 

In the tmap here is the regex row3.s.trim().matches("^[0-9]*$")

 

Output would be :

 

0695b00000G63WBAAZ.pngRegards ,

Amine

gjeremy1617088143

Hi, a better regex : "^\\d+$"

Send me Love and Kudos