Strip $ sign from Sequential file

[rxs0005]

hi

I have sequential text files that have $ amounts prefixed to the value and there are several columns.

How do i strip them before i laod them to orcale tables.

Should i define the COLA under seq stage as varchar2 and in oracle as a regular number(8,3)

EG:

Col A ColB ( in oracle )

$4455.444 4455.444


thanks

rxs0005

[DeepakCorning]

use this function in transformer and then load it in the table -->

Convert("$","",Column A)

[chulett]

Should i define the COLA under seq stage as varchar and in oracle as a regular number(8,3)

Yes. There are many ways to strip the dollar sign, one such way would be to use the EReplace function.

[manojkumarnayak]

several ways are there .
you can use shell script to remove $

sed 's/\$//g' < file name>

you can use this script for other files.

it is faster.


regards
manoj