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]

Hi, @Georgia_H 

Please upload sample data as your want output format.

[Georgia_H]

Hi @flying008 

I have attached a sample xlsx with Data Source and Desired Output

Thank you.

[ShankerV]

Hi @Georgia_H 

One way of doing this.

Many thanks

Shanker V 

[Georgia_H]

hi @ShankerV 

Could you upload the .yxmd file for reference? Many thanks.

[ShankerV]

Hi @Georgia_H 

Step 1: Input

Step 2:

Step 3:

 

Many thanks

Shanker V 

[flying008]

Hi,@Georgia_H 

FYI.

[ShankerV]

Hi @Georgia_H 

Step 4: Filter tool

 

Step 5:

 

Step 6:

 

Many thanks

Shanker V

[Georgia_H]

Hi @ShankerV 

Please allow me to share my sample source in xlsx. You applied the List as input hence you can break the paragraph into respective rows. 

My case is all the texts are in 1 cell. Please refer to my sample source.

[Georgia_H]

hi @flying008 

Thanks for the snippet. Could you upload the .yxmd file? I want to see how you did for the Text to Column split.