Visokio website     Downloads     Video tutorials     KnowledgeBase  
Search/Replace: Replacing patterns of letters within text strings? - Visokio Forums
Search/Replace: Replacing patterns of letters within text strings?
  •     Valentina May 8, 2014 6:02PM
    Hi,

    I have a column with Codes like example below.

    SSP
    LSP
    PPP
    SSS
    LLP

    What I would like to achieve is to replace the P and L letters with M and O respectively.Is thereany formula available in 2.9 that can do this? Eventually I would like to have the following table:

    SSM
    OSM
    MMM
    SSS
    OOM

    Thanks
  • 2 Comments
  •     paola May 9, 2014 5:39AM
    You can use Search/Replace block in the DataManager and automate the operation for all records. See imageimage
    Attachments
    SearchReplaceOp.JPG 67K
  •     Valentina May 9, 2014 5:53AM
    Thanks Paola
This discussion has been closed.
← All Discussions

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership