No Spaces

[reinaldo]

I have a table that I have to export as a text file. One of the fields in the table is the account field. Some of the records display as 22 256 7894. The problem is that when I export the table the account value has to show as 222567894,no spaces. I can export the table just fine, but is there a code that I can put in to export the values without spaces?

Thanks All

 

[Langley]

I would do a full query of the original table, then convert the resulting answer table before exporting it. Use code similar to the following. It assumes account numbers are all the same pattern and could stand some error checking for blanks.

var
 tc          tCursor
 ar Array[]  String
 acNum       String
endvar
;
;run this after the query
;
tc.open(":priv:answer.db")
;
scan  tc:
;
  acNum = tc."AccountNumber" ; your field
  acNum.breakApart(ar)
  acNum = ar[1]+ar[2]+ar[3]
  tc."AccountNumber" = acNum
;
endscan

After running this just export Answer.db. Only the AccountNumber field will be changed.

If the account number 'structure' varies from what you presented, it would require a few more lines to anticipate and deal with variances.



Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[reinaldo]

Tried a different variation but your posting really helped.

Thank you

 

[Kliot]

Reinaldo,

I'm curious, what type of field is tha accont field? If it's a alpha field the field should have exported the spaces.

Perrin