SOLVED
How to remove commas
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
tsumadeep
6 - Meteoroid
‎08-01-2023
05:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
for below challenges I tried with Trim, Replace, functions in formula, But I didnt got the expected output as mentioned below, Can an one please help over this
CASE 1:Input
" |
,, |
,, |
ID,True |
ID,False |
,, |
Now I want to remove ",," can any one help how can I do this, below mentioned is the output, How can I get
Output
ID,True |
ID,False |
CASE 2:
BD |
CG |
, |
seg,Foun |
seg,Foun |
, |
Now In case2 I want to remove "," below mentioned is the output, How can I get,
Output:
BD |
CG |
seg,Foun |
seg,Foun |
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
2 REPLIES 2
jdminton
12 - Quasar
‎08-01-2023
05:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Using Replace([Field1], ",","") will remove all commas from the data. Using ",," only replaces instances where there are two in a row.
Felipe_Ribeir0
16 - Nebula
‎08-01-2023
05:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
