Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by nab03

  1. nab03

    SUBSTR for mutibyte.

    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
  2. nab03

    SUBSTR for mutibyte.

    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...
  3. nab03

    SUBSTR for mutibyte.

    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...
  4. nab03

    SUBSTR for mutibyte.

    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...
  5. nab03

    Output to CSV file

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

    Output to CSV file

    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...
See more

Part and Inventory Search

Back
Top