replace comma with next line character at even position

[madhukar]

Hi All,

i need to replace every even position comma (2, 4, 6...n) in the input row into a next line character.

Thanks in advance

[ArndW]

I think this is a good case for a partial server job solution. Read the input as a single column and call up a BASIC routine like this:

Code: Select all

   EQUATE Comma TO ','
   EQUATE LF         TO CHAR(10)
   Ans = InString ;** assing the input value to the output string
   CommaCount = DCOUNT(Ans,Comma)
   IF MOD(CommaCount,2) <> 0 AND CommaCount THEN CommaCount -= 1
   FOR x = CommaCount TO 2 STEP -2
      Ans[Index(Ans,Comma,x),1] = LF
   NEXT x

[ray.wurlod]

Are there commas in the data (in quoted character strings) or only as field delimiters?

[kumar_s]

You can use translator from unix as well

Code: Select all

tr ',' '\n' < filename

[ray.wurlod]

How to do every second comma using tr command?

[DSguru2B]

If you have to go with OS then use awk. awk can get this done.

[kumar_s]

How to do every second comma using tr command?

Yeah, I didn't noticed this.
You can use

Code: Select all

tr ',' '\n' < filename | paste -d',' - -

[madhukar]

Thanks for all the answers

But i have to do it in datatsage and
input rows are of varying length i.e all rows will have even number of columns but number of columns is not same in each row and it is a comma delimited file

[kumar_s]

In this case, you need to either Basic Transformer to call the BASIC routine, or need to compose a C Routine.

[ArndW]

Kumar - I am staying out of this one. The poster has gotten several viable options presented to him/her so far.

[DSguru2B]

But i have to do it in datatsage and ....

You have several solutions now. Pick your choice. Get as far as you can and if you have any problems, come back with what you have done and whats not working.

[madhukar]

Thanks all