Hello Team,
I have attached the sample input.
My query is to convert one column into 4 columns . I have data in input column as "ZZ98** ABCDEF ************* AAAAA UUUU"
I want to split this above mentioned cell into 4 columns like
1st Column - ZZ98
2nd Column - ABCDEF
3rd Column - AAAAA
4th Column - UUUU
I have attached the sample input and desired output here.
Please support me on this.
| Input |
| ZZ98** ABCDEF ************* AAAAA UUUU |
| ZZ98INOT WORKING GGGGG |
| ZZ98** SAMPLE INPUT ************* JJJJJ |
| ZZ98***GHIJKLMNOP ************* BBBBB VVVV |
| ZZ98** SAMPLE OUTPUT ************* KKKKK |
| ZZ98***KEEP THE DATA ************* LLLLL |
| ZZ98***QSRTUVWXYZASDFG ************* CCCCC WWWW |
| ZZ98***DON’T KEEP THE DATA ************* MMMMM |
| ZZ98***ERROR IN DATA ************* NNNNN |
| ZZ98***DO NOT CHANGE ************* DDDDD XXXX |
| ZZ98*** PLEASE CHANGE ***** EEEEE 01_09_1985 |
| ZZ98ITS WORKING FFFFF +YYYYY 01_09_1985 |
| ZZ98*** MARK THE DATA ***** PPPPP |
| ZZ98 CONTROL NOT AVAILABLE ***** OOOOO |
| Output 1 | Output 2 | Output 3 | Output 4 |
| ZZ98 | ABCDEF | AAAAA | UUUUU |
| ZZ98 | INOT WORKING | GGGGG | |
| ZZ98 | SAMPLE INPUT | JJJJJ | |
| ZZ98 | GHIJKLMNOP | BBBBB | VVVVV |
| ZZ98 | SAMPLE OUTPUT | KKKKK | |
| ZZ98 | KEEP THE DATA | LLLLL | |
| ZZ98 | QSRTUVWXYZASDFG | CCCCC | WWWWW |
| ZZ98 | DON'T KEEP THE DATA | MMMMM | |
| ZZ98 | ERROR IN DATA | NNNNN | |
| ZZ98 | DO NOT CHANGE | DDDDD | XXXXX |
| ZZ98 | PLEASE CHANGE | EEEEE | |
| ZZ98 | ITS WORKING | FFFFF | YYYYY |
| ZZ98 | MARK THE DATA | PPPPP | |
| ZZ98 | CONTROL NOT AVAILABLE | OOOOO | |
