Parsing of a Data

[DataPirate26]

Hello, 

Can anyone guide me to parse this data from the given below:

||`General Population 10-12-2021$`          -          I need to parse out General Population 

[atcodedog05 · Accepted solution]

Hi @DataPirate26 

Use Regex function like below.

Formula:

REGEX_Replace([Field1], ".*`(.+)\s\d.+", "$1")

Workflow:

Hope this helps : )

[messi007 · Accepted solution]

@DataPirate26,

Data cleansing will do the job as well.

Attached the workflow,

Regards,

[DataPirate26 · Accepted solution]

Hello, 

This worked perfectly. Thanx a lot for your quick help. 

[atcodedog05]

Happy to help : ) @DataPirate26 

Cheers and have a nice day!