0

Input:

Column-x

9dtsscmdb F-cmdbuse1ssh SWNA\func-mit-snow-dscvry WOC\9dtsscmdb atoscmdb cngban\9dtsscmdb dtsscmdb dtsshmc idmzsena\9dtsscmdb mgmtprod\_sndiscovery root srvdata swna\9dtsscmdb wdw+9dtsscmdb wdw\9dtsscmdb

Expected Output:

enter image description here

Note:

Column-x1 --> whenever there's integer it needs to be filtered out

Column-x2 --> CAPS values to be filtered out

Column-x3 --> Prefix data(remaining data)

Kiran Balusu
  • 1
  • 1
  • It looks like you are looking to create a regex, but do not know where to get started. Please check [Reference - What does this regex mean](https://stackoverflow.com/questions/22937618) resource, it has plenty of hints. Also, refer to [Learning Regular Expressions](https://stackoverflow.com/questions/4736) post for some basic regex info. Once you get some expression ready and still have issues with the solution, please edit the question with the latest details and we'll be glad to help you fix the problem. – Wiktor Stribiżew Nov 19 '20 at 12:31
  • @WiktorStribiżew updated my question, can you pls look into it now? – Kiran Balusu Nov 19 '20 at 17:32
  • Hi Kiran, what is your code that fails to work properly? SO is not a free coding service, you know, we help solve *programming issues*, not doing all work for others. – Wiktor Stribiżew Nov 19 '20 at 18:03

0 Answers0