How to eliminate , in a file

gp_parag · New User Joined: 11 Jun 2007 Posts: 2 Location: Chennai

Hi everyone,

need a solution for this problem...

A record in a file has contents like this

745,221,059

Using a fileaid command how can I eliminate the "," from this record

Could any one illustrate using a code

William Thompson · Posted: Tue Jun 12, 2007 4:49 pm

Don't know fileaid, but there have been several sort solutions posted here in the past.....

expat · Posted: Tue Jun 12, 2007 4:59 pm

And REXX will do it too

loga_nathan_m · New User Joined: 07 Jun 2007 Posts: 40 Location: India

hi,

hope using fileaid you cannot eliminate a particular column.

you can only eliminate records depending on a particular condition.

u can eliminate the comma(,) by using sort command.

dick scherrer · Posted: Tue Jun 12, 2007 5:57 pm

Hello,

Keep in mind that the posted solution will only work if the value is exactly 9 digits and 2 commas. Often that may not be the case in the real data.

gp_parag · New User Joined: 11 Jun 2007 Posts: 2 Location: Chennai

Hi Loga,
I see ur solution with respect to the format I gave...
but my requirement is to look for comma & then eliminate it from the file.
The comma can occour anywhere say.

Could you help me out

Devzee · Posted: Wed Jun 13, 2007 12:02 pm

dick scherrer · Posted: Wed Jun 13, 2007 6:24 pm

Hello,

If you inspect and find a comma, what would you replace it with?

Keep in mind that the commas are between some numbers, the numbers must be "shifted" together - "12,345,678" would become "12345678" not "12 345 678".

Devzee · Posted: Wed Jun 13, 2007 8:56 pm

I agree with you dick.

Please Ignore my response.

dick scherrer · Posted: Wed Jun 13, 2007 11:32 pm

Hello,

What else is in this file? How many fields are there in a record? How many might have commas (or other punctuation) this might need to be removed?

Is this strictly a Compuware question or might some other tool be acceptable?

If better served, i will move this to a different place in the forums. . .