DSXchange

Hi,

I have a situation where i need to separte words:

Ex:

My input data looks like
CHICAGO CITY
ABC XYZ
A CNBC H.

I need to separate one word char(30) into 3 words.
col1,col2,col3
CITY,CHICAGO
XYZ,ABC
CNBC,A,H.

The length of these characters in each line are different and they are not uniform through out the file.

is there are method to identify spaces among words and when found pull first and so on

Please advice!

Use COUNT to get the number of spaces, add 1, then use FIELD to pull each of them from your space delimited string. Or skip the COUNT if it is always three (max).

chulett wrote:Use COUNT to get the number of spaces, add 1, then use FIELD to pull each of them from your space delimited string. Or skip the COUNT if it is always three (max). ...

Thank You

I will work using this and let you know how it goes

What rule governs the order of words in the output?

Hmmm... I thought it was just bass-ackwards order but closer examination of the evidence provided by the defense suggests otherwise.

That's my requirement :(

Is there any method to select first word and then second word sepated by spaces.

abc xyz input

output should be:
col1 col2
abc xyz

And spaces between words are different for each words.

I have tried chulett's suggestion and was able to create some records.Please advice!

Sure. Field(InputField," ",1,1) would get the first word from a space delimited InputField, Field(InputField," ",2,1) would get the second one. Field(InputField," ",1,2) would get the first and second "word" at once. Etc.

Thank You Chulett .

I was able to produce output file usinf field command. :D

Cool. Time to mark this as Resolved then, using the button at the top of the screen.