delimiter

harikumar · Post by **harikumar** » Sat Jul 03, 2010 9:10 am

my oracle table data is
ename
sri<>rama<>krishna

i want to do delete <> before load the data into source sequentialfile.

Sreenivasulu · Post by **Sreenivasulu** » Sat Jul 03, 2010 9:11 am

1.Click 'search' in this forum
2.Go through the documentation

Regards
Sreeni

chulett · Post by **chulett** » Sat Jul 03, 2010 9:19 am

Check out the Convert() function. Use it twice.

ray.wurlod · Post by **ray.wurlod** » Sat Jul 03, 2010 2:30 pm

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.

chulett · Post by **chulett** » Sat Jul 03, 2010 4:38 pm

True, but assuming not, Convert is a perfectly valid solution.

ray.wurlod · Post by **ray.wurlod** » Sun Jul 04, 2010 2:14 am

And, if that assumption holds, you only need one Convert() function.

Code: Select all

Convert("<>"," ",InLink.TheName)

chulett · Post by **chulett** » Sun Jul 04, 2010 6:34 am

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.

venugopal.123 · Post by **venugopal.123** » Tue Jul 06, 2010 2:52 am

Use field function to remove <> in the column...

ArndW · Post by **ArndW** » Tue Jul 06, 2010 3:12 am

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.