Find last valid comma and remove strings (City/Country) after that
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I have completed the workflow design for my process with Alteryx. In that I am facing issue to identify a comma at last of a string. I have tried with Regex and String manipulation, but still facing issues with that. Could you please check below scenarios and help me with a solution for this issue.
Input | Output | Comments |
Counterparty Name, City, Country | Counterparty Name | I know it is not possible to identify the city name and country name using Alteryx, so here the expected output is Counterparty Name, City |
New A.B., Counterparty Name, City, Country | New A.B., Counterparty Name | I know it is not possible to identify the city name and country name using Alteryx, so here the expected output is New A.B., Counterparty Name |
New A.B., Counterparty Name, Country | New A.B., Counterparty Name | No Issues, removed everything after the last comma |
New A.B., Counterparty Name., Country | New A.B., Counterparty Name. | No Issues, same as above |
New A.B., Counterparty Name., Country, | New A.B., Counterparty Name. | Facing issue since we have a comma at end of this name
|
- Labels:
- Designer Cloud
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Is it possible to share a copy of your workflow? Are you wanting to remove all City and Country info from your data?
Also, what comes to mind is you could use the formula trimright([Input],",") to remove all commas at the end of your string.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for your reply, I will check with the steps you have mentioned.
yes, I want to remove all the City and Country Names from my Input.
