Seperating the string

[thatiprashant]

Hi Guys.

I am working on mainframes and looking to split the colum info into two parts as i get the data like #kkkkkkkk# 19,trdgar place, USA
i need to seperate the field with address in one column and the other part in # # be in another columns... and they are not fixed width.

Any help is much appreciated.

Thanks
Prashant

[keshav0307]

try Field(%string%,%delimiter%,%occurrence%,[%number%]) function

[thatiprashant]

try Field(%string%,%delimiter%,%occurrence%,[%number%]) function

thanks keshav for ur reply...

actually it is not the number it always starts with after # # this data.

thanks

[thatiprashant]

try Field(%string%,%delimiter%,%occurrence%,[%number%]) function

thanks keshav for ur reply...

actually it is not the number it always starts with after # # this data.

thanks

[ray.wurlod]

You are going to need to assemble the fields into a single field, so that a string such as the one in your original post occurs. Then apply the Field() function to that, returning everything after the second "#" character.

Code: Select all

Field(assembled_data, "#", 3, Count(assembled_data, "#") - 1)

If you get unusual "job parameter" errors, change "#" to some other character when creating the assembled_data string.