Page 1 of 1
delimiter
Posted: Sat Jul 03, 2010 9:10 am
by harikumar
my oracle table data is
ename
sri<>rama<>krishna
i want to do delete <> before load the data into source sequentialfile.
Posted: Sat Jul 03, 2010 9:11 am
by Sreenivasulu
1.Click 'search' in this forum
2.Go through the documentation
Regards
Sreeni
Posted: Sat Jul 03, 2010 9:19 am
by chulett
Check out the Convert() function. Use it twice.
Posted: Sat Jul 03, 2010 2:30 pm
by ray.wurlod
If your data are likely to contain single "<" or ">" characters prefer the Ereplace() function. This is not supplied by IBM for parallel jobs, but one of our posters has posted the code here on DSXchange.
Posted: Sat Jul 03, 2010 4:38 pm
by chulett
True, but assuming not, Convert is a perfectly valid solution.
Posted: Sun Jul 04, 2010 2:14 am
by ray.wurlod
And, if that assumption holds, you only need one Convert() function.
Posted: Sun Jul 04, 2010 6:34 am
by chulett
True again! For some reason, had it stuck in my head that it only did one character - literally. Forgot about the whole matching list bit.
Posted: Tue Jul 06, 2010 2:52 am
by venugopal.123
Use field function to remove <> in the column...
Posted: Tue Jul 06, 2010 3:12 am
by ArndW
venugopal.123 wrote:Use field function to remove <> in the column...
I don't think that the field function is usable here. The FIELD() delimiter is a single character and not the 2-character sequence required here.