String...

[Sot]

I have input string
Input val=195.4,280.0,,,301.3,,,441.9,

In that i need to elemnate the empty"" values...

Expected output is:195.4,280.0,301.3,441.9,


Sot

 

[onpnt]

which part of the process are you having problems with?

_____________________________________________________________________

http://www.onpntwebdesigns.com/aspTut4.asp

 

[mwolf00]

myVal = "195.4,280.0,,,301.3,,,441.9,"

myArr = split(myVal,",&quot
for x = 0 to uBound(myArr)
if isNUmeric(myArr(x)) then
outStr = "," & myArr(x)
end if
next

outStr = mid(outStr,2) 'take off first comma'


Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[Sot]

Dear mwolf00

I am getting only last value....

Sot

 

[mwolf00]

DOH!!! Sorry


myVal = "195.4,280.0,,,301.3,,,441.9,"

myArr = split(myVal,",&quot
for x = 0 to uBound(myArr)
if isNUmeric(myArr(x)) then
outStr = outStr & "," & myArr(x)
end if
next

outStr = mid(outStr,2) 'take off first comma'




Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[Sot]

Dear mwolf00

I am getting Answer Now...Thanks for your help...
Good solution..
Sot