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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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