How to remove special characters i.e hypen (-)

(0) Share

Report

Posted on by moerah

327

Hi all

I need help removing special characters such as dash, hypen (-) and replacing them with space, on my existing formula

formula:

With(
 {
 varw: Split(
 DataCardValue6.Value,
 " "
 ),
 varNo: 2// Define the variable varNo here
 },
 If(
 CountRows(varw) > varNo,
 Concatenate(
 Index(
 varw,
 varNo
 ).Value,
 " ",
 Index(
 varw,
 varNo + 1
 ).Value
 ),
 CountRows(varw) = varNo,
 Last(varw).Value
 )
)

current issue:

Thank you all 😀

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

BhargavPatel 660 Moderator on at

Like (0)

Report

There is some info missing somewhere. I don't see how the code you have posted is generating the Document Name with hypens.

Was this reply helpful? Yes No
Verified answer

moerah 327 on at

Like (0)

Report
hi @BhargavPatel thank you for the reply

I figured it out, all I had to do was
Concat(attach_1.Attachments, Substitute(Name, "-", " "))
on DataCardValue6.value
got the result I want, now I'm off to the next problem 😀

thank you

Was this reply helpful? Yes No