how to check spaces at a particular position of a file

Nitin Bhargava · New User Joined: 22 May 2012 Posts: 32 Location: india

Hi All,

I want to check spaces on a particular position of a file and if found want to displace the record by some bytes.

Input file is having following record

Pandora-Box · Posted: Thu Nov 08, 2012 5:27 pm

INREC IFTHEN check for space if it satisfies do the BUILD as per your requirement

Also forgot to ask what will be the lenghth of the output if your input has space in 11th column and has data in rest of the column till 1000

Bill Woodger · Posted: Thu Nov 08, 2012 5:32 pm

Your data doesn't match your description.

Please show sufficient examples and expected output to fully describe what you want.

Nitin Bhargava · New User Joined: 22 May 2012 Posts: 32 Location: india

Hi,

Even though the file is of 1000 bytes the record is max of 480 byes so there are no chances of truncation.

My question is: I want to check the first space encountered starting from 11th byte. Suppose the first space is at 17th byte, In that case I have to keep the first 17th byte as it is and rest of the data should start from a fixed position 30th byte.
The other situtation could be: First space is encountered at 15th byte, In that case I have to keep the first 15th byte as it is and rest of the data should start from a fixed position 30th byte.

Please let me know am I clear now

.

Bill Woodger · Posted: Thu Nov 08, 2012 5:46 pm

In your example, the first space after the 11th byte is the one before MICHAEL.

Nitin Bhargava · New User Joined: 22 May 2012 Posts: 32 Location: india

oops its a typo...Actually in my example NEWYORK is combined.
Anyway i want it to be checked from 11th byte itself.

Bill Woodger · Posted: Thu Nov 08, 2012 5:55 pm

Well, I'm not so sure if you can just stick NEWYORK itself together if you feel like it, but I've edited your original post to reflect this.

Nitin Bhargava · New User Joined: 22 May 2012 Posts: 32 Location: india

Do you think we could do this using sort or icetool.

vasanthz · Posted: Thu Nov 08, 2012 6:10 pm

Hello,
If you post some input sample records with output records and explain all the possibilities, then someone will be able to give you a apt solution.

Bill Woodger · Posted: Thu Nov 08, 2012 6:29 pm

Beyond the 11th byte, are the positions of the remaining fields in the record variable?

Is this another attempt at your previous topic, which you seemed to lose interest in?

Nitin Bhargava · New User Joined: 22 May 2012 Posts: 32 Location: india

Hi Bill,

I did my previous one by dividing it in multiple steps. Since this one is a bit straight forward I am thinking not to increase the steps in my job.

Here are some more example for this one

Bill Woodger · Posted: Thu Nov 08, 2012 9:03 pm

You didn't answer, so let me ask in a different way.

Is your file

Fixed-length of "stuff"
Fixed-length of "name-stuff" to be re-arranged
Fixed-length of "rest-of-stuff"

Or

Fixed-length of "stuff"
Variably-positioned "stuff" including "name-stuff" to be rearranged

?

Nic Clouston · Posted: Fri Nov 09, 2012 2:19 am

dick scherrer · Posted: Fri Nov 09, 2012 3:48 am

Hello,

While your question is probably quite clear to you, it is not to everyone else. You need to clarify the info you have posted because it is confusing some (me<g>) of us.

Act like the max length (your 1000) is only 60. Then act like your 480 is only 20. Then show a few examples using these sizes (the ones you already have may work or they may need modification.