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 |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |