parsing data

[bh1789]

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 solution]

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.

[bh1789]

Thank you very much!