Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
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。