Search results for query: *

Hi Blom. Thanks for your promt reply and great help. you are so smart and very kind of me. I'll try this complex way. nab

Hi Blom. Thanks for your reply. and Sorry for my slow reply. I have to give you more information again. >IIF((substr(field),1,1),'X',2,1)+ >IIF((substr(field),2,1),'X',2,1)+ >IIF((substr(field),3,1),'X',2,1) it's nice idea. but I can't. because The Japanese language has too many kind of 2byte...

Hi Blom. Thanks for your prompt reply. I have to give you more information. >"SUBSTR("XX6X132-6",0,5)" I know this is right. But how about this case.. if data is "XXXX132-6". if i wrote "SUBSTR("XXXX132-6",0,5)", this result is "XXXX1". I hope I can get "XXXX". <- 8byte #X is 2byte...

Hi ALL.. Im nab at japan. I have a question. Im using Informatica PowerCenter7.1.2. I want to convert from my textfile to flat file as CSV using "SUBSTR" function with multibyte. for example ## XXX is multibyte chara(Shift_JIS) --------my txt file----- No | country | name |desc 1|japan|nab...

Thank you Blom! I could output to CSV file. after changed target properties in workflow manager. Thanks a lot!!

Hi ALL.. Im nab. I have a question. Im using Informatica PowerCenter7.1.2. I wanna output to file as CSV file. like below one. ------ I hope this ---- "vcolumn1","vcolumn2","vcolumn3","iColumn4" "data1_1","data1_2","data1_3",0 "data2_1","data2_2","data2_3",0 "data3_1","data3_2","data3_3",0...