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.
Using Replace([Field1], ",","") will remove all commas from the data. Using ",," only replaces instances where there are two in a row.