return value, different length

[tiverson]

Trying to return values from original list, without the [-] 510S_ items or the 510S_

The PC Group column is what I am trying to come up with

[atcodedog05 · Accepted solution]

Hi @tiverson 

Here is how you can do it.

Workflow:

Hope this helps : )

[MarqueeCrew · Accepted solution]

maybe something simple might be helpful...

IIF(Contains([Company],"[-]"),'',Replace(Replacechar([Company],"510S",''),"_",'')))

Cheers,

Mark

[Jonathan-Sherman · Accepted solution]

Hi @tiverson,

I would use a regex approach to parse out the numeric part:

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

[binuacs · Accepted solution]

@tiverson 

IIF(REGEX_Match([Company], '^(510S)\_(\d+)'), REGEX_Replace([Company],'.+_(\d+)','$1'),Null() )

[MarqueeCrew]

@tiverson ,

Thank you for marking my solution as "a" solve.  Please do try other solutions and you can mark as many of them as "SOLVES" as your time permits.  It encourages others to contribute and might make for an interesting discussion.

Cheers,

Mark

[tiverson]

I also need the characters returned, not just the numbers.  My original screenshot did not show all of my data.

[atcodedog05]

Hi @tiverson 

Provide excel with sample data.

[tiverson]

My original post had all of the excel data

[tiverson]

file attached