Now problem here is that S9 maybe of two types. In the first one i.e. S9(7) C3
it works fine but for second one i.e. S9(11)V9(2) C3 I have to CONCATENATE "s370fpd" with value inside bracket of V9 i.e. 2 in this case. So it will become "s370fpd5.2".

Since the value inside bracket is dynamic hence the logic has to search inside it. I am not sure how it will check and then append it.

It also appears to me that you can turn CONCATENATE("$ebcdic",5,".") into "$ebcdic5." directly and CONCATENATE("s370fpd",5,"." into CONCATENATE("s370fpd5.", and/or use & to make things a little shorter, but that's only subject to what you've put in your question: