Regex Tool: Extracting characters

[rajatsadan]

Hi, I was working on a dataset and wanted to extract an expression between 2 characters :

Sample Dataset:

T14s |1300g| 25cm 30cm 33cm Black

In the above expression I wanted to retrieve only the following information: 1300g

I tried the following expression: \|\d{4}\|

The data parsed was as follows: |1300g|

Ca anyone let me know how to avoid the | characters in the parsed data?? Much appreciate. 

[atcodedog05 · Accepted solution]

Hi @rajatsadan ,

Here is the expression use it in RegEx tool parse

.*\|(\d{4}.)\|.*

[atcodedog05 · Accepted solution]

Hi @rajatsadan ,

Here is a workflow for the task.

Input : T14s |1300g| 25cm 30cm 33cm Black

Output :

Workflow

Hope this helps : )

If this post helps you please mark it as solution. And give a like if you dont mind😀👍

[vizAlter · Accepted solution]

Hi @rajatsadan —  Try this solution too...use the expression below in a RegEx tool with Parse output method

\|(.+)\|

[rajatsadan]

Thanks!!

[rajatsadan]

Thank you!!

[vizAlter]

Thank you!

[atcodedog05]

Happy to help : ) @rajatsadan 

Cheers and Happy Analysing 😀