Parsing sting data

M

Mark

Hello all,

I have a string of data that I need to parse once I move over 181. This is
not lines, but character spaces. What is the command or procedure to count
char spaces?

Thanks
 
M

Mark

Well I found it, or at least a way to do it. I'm using the Left(string,181).

I have another question now. How do I know when I have reached the end of
the string? I would use the EOF and loop if this were records in a file, but
this being a string that varies how do I know when I reached the end?

Thanks
 
D

Douglas J. Steele

Are you perhaps looking for the Len function? It'll tell you how many
characters are in a string.
 
F

fredg

Well I found it, or at least a way to do it. I'm using the Left(string,181).

I have another question now. How do I know when I have reached the end of
the string? I would use the EOF and loop if this were records in a file, but
this being a string that varies how do I know when I reached the end?

Thanks
Click to expand...

Len(VariableName) will tell you how many characters there are in the
string.
 
M

Mark

I am getting string data from a UNIX box. The string could contain hundreds
of records. I need to read through it and after going 181 char then use the
“& CrLf†to start a new line. Once I read through it all I will create a
text file. Would this be the way to use that Len fuction to get the result I
am trying to get?

vLen = len(mystring)

vResults = vResults + left(myString, 181)

vCnt = vCnt + 181

if vCnt = vLen then

end


I see another issue too now that I look at this. If I use the “181†and
left function then it will always read the first record. How would I read a
string and get the first record (181 length) then move on over to the Second
record (starting at 182 end at 363)?

Thanks!
 
J

John Nurick

It might be simpler to fix the data at the Unix end. Filtering it
through this will insert a Windows-style line break after each 181
characters:

perl -wpe"chomp; s/(.{181})/$1\x0d\x0a/g"
 
Top