SOLVED
Removing data Assisstance?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SahilArora3139
8 - Asteroid
‎12-18-2023
11:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi all
can someone help me what should be done for this situation:
s.no. Name Address
1. A$. NY
2. A. UK
3. C$. CA
i want to remove the data having dollar($) in Name column.
output should be:
2. A. UK
others two should not be there as it have dollar sign in Name column .
please help
Solved! Go to Solution.
Labels:
- Labels:
- Macros
- Output
- Transformation
4 REPLIES 4
binuacs
21 - Polaris
‎12-19-2023
01:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@SahilArora3139 In the filter tool add the condition
!Contains([Name],'$')
‎12-19-2023
02:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you so much
‎12-19-2023
02:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Just one small thing, if i want to segregate pattern having $ sign at the end only then it will work the same?
like
A$
$A
A
so $A is acceptable andhence A and $A should be the output
only the name having dollr in end needs to be excluded
binuacs
21 - Polaris
‎12-19-2023
02:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
