Hello, sorry if this has a blatantly obvious answer, but I’m trying to see if it’s possible to run multiple SUBSTITUTE() expressions in one column?
I’d like to do something like this:
SUBSTITUTE([ColumnA], “RandomExample1”, “Random-Example-1-Substitution”)
AND
SUBSTITUTE([ColumnA], “RandomExample2”, “Random-Example-2-Substitution”)
AND
SUBSTITUTE([ColumnA], “RandomExample3”, “Random-Example-3-Substitution”)
Many thanks for any help!
Solved! Go to Solution.
Try:
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
[ColumnA],
“RandomExample1”,
“Random-Example-1-Substitution”
),
“RandomExample2”,
“Random-Example-2-Substitution”
),
“RandomExample3”,
“Random-Example-3-Substitution”
)
So are you trying to get 3 copies of a single column with different substitutes of that column or do you want like Substitute “.” for “,” then Substitute “!” for “?”, etc…?
So like
“Shascher. need help with this question!”
becomes
“Shascher, need help with this question?”
Try:
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
[ColumnA],
“RandomExample1”,
“Random-Example-1-Substitution”
),
“RandomExample2”,
“Random-Example-2-Substitution”
),
“RandomExample3”,
“Random-Example-3-Substitution”
)
@Steve Fantastic! I had the syntax wrong, but this works great!
Also, @Austin_Lambeth, many thanks for your reply as well.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |