Answered

My string contains an (

(0) Share

Report

Posted on by RobH1

I have a filename as a string containing among other things "1 (Old" or "2 (Old". The length and structure of the string may change so I can't use split or substring.

In my fx I have:

If( contains( outputs('Compose'), '1 (Old', '1',

If( contains( outputs('Compose'), '2 (Old', '2',

''))

It's part of a much bigger line of code finding various bits of the string using contains, every other bit is working fine but this part is failing, I assume because there is an open bracket in the string.

Any advice? Thanks

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

mahoneypat 1,720 on at

Like (0)

Report
Copy link

Link copied!

Can you use the replace() function before this step to replace the (s with a unique character?

Pat

Was this reply helpful? Yes No
Ellis Karim 11,793 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
I think what may be happening here is that the second if statement is missing the false condition?
Try:
if(contains(outputs('Compose'),'1 (Old'),1,if(contains(outputs('Compose'),'2 (Old'),2,'NO MATCH!'))
The if condition requires: If(condition, true, false)

Ellis

Was this reply helpful? Yes No
RobH1 60 on at

Like (0)

Report
Copy link

Link copied!

Hi, It's not that, it has a false condition, it's just blank with ''. You are correct though I am missing the ) from my code after (Old' should be (Old') but it still fails.

Was this reply helpful? Yes No
RobH1 60 on at

Like (0)

Report
Copy link

Link copied!

Thanks, I had thought of that after posting but wanted to avoid it as both ( ) occur throughout the string so I have to replace both with unique characters and re write everything but that and adding the missing ) to my code does work.

Just seems odd that it wouldn't ignore the ( when it is wrapped in '' making it part of the string and I wondered if I was missing something.

Final code now looks like:
Compose = replace( replace( substring( items('Apply_to_each')?['{Name}'],8),'(','^'),')','^')
fx to extract the bit I want =
If( contains( outputs('Compose'), '1 ^Old'),'1', If( contains( outputs('Compose'), '2 ^Old'),'2','')

Was this reply helpful? Yes No