Imports System.Collections.Generic
For Each word In SplitStringToPartWithWordsAndFixedLength("20/F Kowloon XXXXXxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx axxxxxxXXXXXXXXxxxxxxxxxxxxxxxXXXXXXXXXXXXXXXXXXXXXXXXx Kowloon Kowloon Kowloon Kowloon Kowloon 1 Wang Yuen Street Kowloon Bay Hong Kong" , 40)
Private Function SplitStringToPartWithWordsAndFixedLength(strInput As String, intLength As Integer) As String()
Dim words() As String = strInput.Split(" ")
Dim sentenceParts As List(Of String) = New List(Of String)
sentenceParts.Add(String.Empty)
Dim partCounter As Integer = 0
If word.Length > intLength Then
Dim intWordLength as Integer = intLength - sentenceParts(partCounter).Length
sentenceParts(partCounter) += word.Substring(0, intWordLength)
word = word.Remove(0, intWordLength )
If word.Length>0 andalso word.Length < intLength then
partCounter = partCounter + 1
sentenceParts.Add(word + " ")
partCounter = partCounter + 1
sentenceParts.Add(String.Empty)
Loop Until word.Length = 0
If sentenceParts(partCounter).Length + word.Length > intLength Then
partCounter = partCounter + 1
sentenceParts.Add(String.Empty)
sentenceParts(partCounter) += word + " "
Return sentenceParts.ToArray()