The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
replace string with single quote string
Saurabh_Sawant_24
Member Posts: 7 
Learner II
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'
SENDER BANK
RECEIVING BANK
SENDER
RECEIVER
I want a result in single string as follows:
'SENDER BANK','RECEIVING BANK','SENDER','RECEIVER'
Tagged:
1
Best Answer
-
kayman
Member Posts: 662 
Unicorn
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)8
