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
Seperating the string
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 25
- Joined: Mon Sep 19, 2005 11:32 am
-
- Participant
- Posts: 25
- Joined: Mon Sep 19, 2005 11:32 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
If you get unusual "job parameter" errors, change "#" to some other character when creating the assembled_data string.
Code: Select all
Field(assembled_data, "#", 3, Count(assembled_data, "#") - 1)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.