In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Remove special characters and some string

johnparecto
7 - Meteor

Hello Community,

Asking your help if you can share what steps or condition (formula) what will I do to the following:

Current data:

I want to remove some data and characters.

- <CdtTrfTxInf>- <PmtId>  <InstrId>3VNUG</InstrId>  <IntrBkSttlmAmt Ccy="GBP">98.40</IntrBkSttlmAmt>
- <CdtTrfTxInf>- <PmtId>  <InstrId>3O7G</InstrId>  <IntrBkSttlmAmt Ccy="GBP">2052.00</IntrBkSttlmAmt>
- <CdtTrfTxInf>- <PmtId>  <InstrId>3OWP5</InstrId>  <IntrBkSttlmAmt Ccy="GBP">94726.50</IntrBkSttlmAmt>


And I want to look like this way.

 

3VNUGGBP98.40
3O7GGBP2052.00
3OWP5GBP94726.50

 

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

Hey @johnparecto, is this format consistent? If so, you should be able to isolate these elements with RegEx. Here's a quick example I've put together:

 

Output:

1515.png

 

Formula expressions:

1616.png

 

If you're not going to have any other numbers/decimal points in your [Field4] then you could even simplify the RegEx massively and use:

 

REGEX_Replace([Field4], '[^0-9.]', '')

 

Hopefully this is useful! Please shout if you have any questions etc.

johnparecto
7 - Meteor

Thank you so much! It helps.

Labels
Top Solution Authors