Results 1 to 2 of 2

Thread: How to replace special characters in informatica

  1. #1
    Senior Member
    Join Date
    Aug 2012
    Posts
    40,312

    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?

  2. #2
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514
    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

Similar Threads

  1. Replies: 0
    Last Post: 12-22-2012, 04:10 PM

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
  •