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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Karuetl
Creator II
Creator II

Special character at beginning of the row

0683p000009M2e6.png

 

In a file each value is comma separated with enclosed double quotes , i got error when one of the row has special characters , how do i remove it 

Labels (2)
1 Solution

Accepted Solutions
Karuetl
Creator II
Creator II
Author

fixed with below solution 

 

.replaceAll("[^0-9]", "").trim(); 

 

View solution in original post

6 Replies
Anonymous
Not applicable

usually in the string we can use this function it may work 

row1.contains("?")? row1.replace("?","")

And question from my end is it at the start of the line in the file 

Karuetl
Creator II
Creator II
Author

yes start of the line in the file 

Anonymous
Not applicable

have you tried this option below

 

 

0683p000009M2eB.png

Karuetl
Creator II
Creator II
Author

tried but it enclosed twice double quotes instead of single 

 

0683p000009M2eG.png

Karuetl
Creator II
Creator II
Author

fixed with below solution 

 

.replaceAll("[^0-9]", "").trim(); 

 

Anonymous
Not applicable

Oh okay , nice, thanks for the update