
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hello
What is the best way to deal with this situation?
I have an external text file.
"BK;1/1000;JRN10069;GG1;-3.223504;-40.696405" ;external file text
I would like to leave you this way
"BK 1/1000 JRN10069 GG -3.223504 -40.696405 " objective
The text 1 to the first (;) can only have a maximum length of 7 characters. If the text is more than 7, return only the first 7. If less than 7, complete with spaces.
The text 2 Second (;) can only have a maximum length of 12 characters. If the text is more than 12 return only the first 12. If it is less than 12 complete with spaces.
[...]
The text 4 fourth (;) can only have a maximum length of 2 characters. If the text has more than 2 return only the first 2. If it has less than 2 complete with spaces.
Okay, I can transform the string into a list and manipulate them independently, but how to deal with fixed length? not letting an item be different from what is allowed?
Solved! Go to Solution.