Parsing Data

[swhitmeyer]

I need to parse the following data attached - I am not sure the best way to do it. We need to split out the 4 digit Cd field. Thank you!

[mceleavey]

Hi @swhitmeyer ,

Use a formula field and create the formula LEFT([Current Data],4)

that should do the trick.

M.

[swhitmeyer]

Were you able to see the attachment? The data is in all different formats so it is not that simple. For example, EE74/85 needs to be split out into different columns as EE74 and EE85.

[mceleavey]

Yeah, I see it now.

I've built the workflow. It's messy, but does the trick.

M.

[swhitmeyer]

Thanks this looks better and you did that so fast! Row 7 and 9 does not produce desired data, any thoughts?

[mceleavey]

Ha, it's not my first time ;)

Yeah, I noticed that. It may need a bit of tweaking on the regex, but it's almost there.

I'll have a look when I can.

M.

[swhitmeyer]

Thank you very much!!

[mceleavey · Accepted solution]

...even messier, but should work.

*fingers crossed*

[swhitmeyer]

Thank you very much!!

[mceleavey]

You're very welcome.

M.