replace string with single quote string

Saurabh_Sawant_24
Saurabh_Sawant_24 New Altair Community Member
edited November 5 in Community Q&A
I have a column attribute with  following values as

SENDER BANK
RECEIVING BANK
SENDER
RECEIVER

I want a result in single string as follows:
'SENDER BANK','RECEIVING BANK','SENDER','RECEIVER' 
Tagged:

Best Answer

  • kayman
    kayman New Altair Community Member
    Answer ✓
    Step 1 : Replace your attribute as follows : find ^(.*)$ and replace with '$1' , this already quotes your attribute
    Step 2 : Use the aggregate operator and use concatenate. Now you will get 'SENDER BANK'|'RECEIVING BANK'|...
    Step 3 : Replace \| (escaped pipe symbol) with , (comma)

Answers

  • kayman
    kayman New Altair Community Member
    Answer ✓
    Step 1 : Replace your attribute as follows : find ^(.*)$ and replace with '$1' , this already quotes your attribute
    Step 2 : Use the aggregate operator and use concatenate. Now you will get 'SENDER BANK'|'RECEIVING BANK'|...
    Step 3 : Replace \| (escaped pipe symbol) with , (comma)

Categories