parsing data

Question

I have a field of data that if is correct will come through as 15 chacs as shown below:

ECW221206-04240

Sometimes the data is incorrect and comes through without the "-" as shown below:

ECW22120604240

How would I add a "-" in the 10th position, ONLY if the "-" is not already included in the data?

Thank you!

PanPP · Accepted Answer

Hi @bh1789

Please see attached sample WF for the output that contains -

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.