Split string depending upon character count

[lakshmi.mp]

Hi,

I am having a text file paragraph in which each line should store 64 characters and If the
64th Character lies in middle of the word, we have to carry forward that word to next line.
And the data needs to be stored into excel

Please help me, Thanks in advance.

Thanks & regards,
Lakshmi

[muhammedyuzuak]

Hi @lakshmi.mp,

You have a 100 character variable. You want to use the first 64 words and take the rest from there and add them to another field, is it true?

If so you can use bellow.

for the first 64 — yourValue.Substring(0,64).ToString
for after 64 — yourValue.Substring(64).ToString

Regards,
MY

[lakshmi.mp]

Hi,

readData.txt (3.9 KB)
I have attached text file where it has so many characters my code working only for first 64 characters and not working for rest of the characters.

Thanks,
Lakshmi

[Yoichi]

Hi,

The following topic might help you.

If 35 th character lies mid of the word. We need to omit that word in first line and we need to add that full word in second line

Hi, Another solution: strTemp = System.Text.RegularExpressions.Regex.Replace(yourString,"\S+",Function(m) if(m.Index<35 AndAlso m.Index+m.Value.Length>=35,vbcrlf+m.Value,m.Value)) result = System.Text.RegularExpressions.Regex.Replace(strTemp,"^.*",Function(m) if (m.Value.Length>35,m.Value.Substring(0,35)+vbcrlf+m.Value.Substring(35),m.Value)) Regards,

Regards,

[lakshmi.mp]

Hi Yoichi,

This one i tried out but its working only for 1 line of data from text file not working for rest of the lines.

Regards,
Lakshmi
readData.txt (3.9 KB)

[Yoichi]

Hi,

How about the following sample?

Sample20220525-5.zip (4.9 KB)

Regards,

[lakshmi.mp]

Hi Yoichi,

Its working now, thanks a lot for helping.

Thanks & Regards,
Lakshmi