Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
LRAngela
Contributor III
Contributor III

How to split a field based on a fixed number of bytes

hi all,

i want to split a field to some fields,E.g: 

text

1如23 split to       

 1   如     23   

i want use mid()to run it but i found that  it failed。

mid(text,2,2)  it shows that       如2  .  it's wrong.it should be 如.

so,i want to split a field based on a fixed number of bytes,can you help me,thanks!

 

 

Labels (2)
10 Replies
LRAngela
Contributor III
Contributor III
Author

wow!so cool!it ran successfully。Thank you so much you are amazing。