Results 1 to 2 of 2

Thread: How to replace special characters in informatica

  1. 12-09-2012, 01:16 PM #1
    amrutha
    amrutha is offline
    Senior Member
    Join Date
    Aug 2012
    Posts
    114

    How to replace special characters in informatica

    I want to replace the special characters with empty string in informatica. Is there any function in informatica to do this?
    Reply With Quote Reply With Quote
  2. 12-10-2012, 05:45 AM #2
    vijay
    vijay is offline
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    490
    Use the replacestr function to substitute a string with another string. Example is shown below:

    Code:
    replacestr(input_port,'@','$','%','')
    The above function replaces the special characters like @,$ and % with empty string
    Reply With Quote Reply With Quote
« Error: Value larger than specified precision allowed for this column - Informatica | Temporary table creation in Informatica »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules