Community & Support
Learn
Marketplace
Discussions
Categories
Discussions
General
Platform
Academic
Partner
Regional
User Groups
Documentation
Events
Altair Exchange
Share or Download Projects
Resources
News & Instructions
Programs
YouTube
Employee Resources
This tab can be seen by employees only. Please do not share these resources externally.
Groups
Join a User Group
Support
Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
replace string with single quote string
Saurabh_Sawant_24
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'
Find more posts tagged with
AI Studio
RegEx
Accepted answers
kayman
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)
All comments
kayman
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)
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups