Need help on data parsing

[Georgia_H]

Hello everyone.

I have a use case here whereby I need to parse out IDs like root,padmin,pshoot,cybr_rid,secadm,hkqualys from the data source below:

In short, I need to parse out the IDs in between ## Allow root to run any commands anywhere  and  ## Allows members of the 'sys' group to run networking, software,

The format of my source data looks like this:

## The COMMANDS section may have other options added to it.
##
## Allow root to run any commands anywhere
root                    ALL=(ALL) ALL
padmin                  ALL=(ALL) NOPASSWD:ALL,!SH,!SU,!PASSWD
pshoot                  ALL=(ALL) NOPASSWD:PSHOOT
cybr_rid                ALL=(ALL) NOPASSWD:CYBRARK,PASSWD,SU
secadm                  ALL=(ALL) NOPASSWD:SECU
hkqualys                ALL=(ALL) NOPASSWD:SU

## Allows members of the 'sys' group to run networking, software,

Could anyone enlighten me on how to achieve this? Really appreciate any kind inputs.

[flying008 · Accepted solution]

Hi, @Georgia_H 

All string in 1 cell can be split by '\n' to rows, then you can follow the gif of process.

[ShankerV · Accepted solution]

Hi @Georgia_H 

Added the below tools to make sure your input file works.

Many thanks

Shanker V 

[ShankerV]

Hi @Georgia_H 

Step 1: Input the excel file

Step 2: 

 

 

Step 3: This step I am using to change the Column name from Results to Field1 so the previous steps created works for me.

You can ignore if you need.

 

Many thanks

Shanker V

[Georgia_H]

Many thanks @flying008  and @ShankerV  for the prompt support. Kudos to you guys! :)