Remove characters not desired in a field
MavenHello.
I need to get from a Text Fiel in a table a number inside.
The field contains that:
{"op":"&","c":[{"type":"date","d":">=","t":1480582800},{"type":"group"}],"showc":[true,true]}
I need only the number. I can't remove {} [] characters, I've been using Replace operator to remove the other characters.
How can I do to extract the number and remove {}[] characters? Is there other way to extract the number without Replace operator?
Best Answers
-
Options
kayman
Member Posts: 662 
Unicorn
Not sure what you mean, but using this regex as a replacement operation on your original string the result will be
1480582800
Which is in the end what you needed, isn't it?
The example I added shows you this, the document contains your string, the replacement uses the regex and the outcome will be your number
1 -
Optionskayman
Member Posts: 662 Unicorn
Then you use the regex in a replace operator.
like this :
<?xml version="1.0" encoding="UTF-8"?><process version="7.6.001">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="7.6.001" expanded="true" name="Process">
<process expanded="true">
<operator activated="true" class="text:create_document" compatibility="7.5.000" expanded="true" height="68" name="Create Document" width="90" x="112" y="85">
<parameter key="text" value="{"op":"&","c":[{"type":"date","d":">=","t":1480582800},{"type":"group"}],"showc":[true,true]}"/>
</operator>
<operator activated="true" class="text:documents_to_data" compatibility="7.5.000" expanded="true" height="82" name="Documents to Data" width="90" x="246" y="85">
<parameter key="text_attribute" value="txt"/>
</operator>
<operator activated="true" class="replace" compatibility="7.6.001" expanded="true" height="82" name="Replace" width="90" x="380" y="85">
<parameter key="attribute_filter_type" value="single"/>
<parameter key="attribute" value="txt"/>
<parameter key="replace_what" value="^.*?"t":(\d+)\}.*$"/>
<parameter key="replace_by" value="$1"/>
</operator>
<connect from_op="Create Document" from_port="output" to_op="Documents to Data" to_port="documents 1"/>
<connect from_op="Documents to Data" from_port="example set" to_op="Replace" to_port="example set input"/>
<connect from_op="Replace" from_port="example set output" to_port="result 1"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="0"/>
<portSpacing port="sink_result 2" spacing="0"/>
</process>
</operator>
</process>I only used a document because your string contains a lot of quotes, but the logic works the same when it is an example set
2 -
Optionskayman
Member Posts: 662 Unicorn
Use the 'parse numbers' operator, this will make an integer from your nominals. Just ensure they are all numeric
2
Answers
Hi @bea11005,
Can you share your dataset, please?
Otherwise, have you try the Extract Information operator of the Text Processing extension (to download and install from the MarketPlace)
Regards,
Lionel
You need to escape the special characters like \{ , this will tell the system to tread it as a 'normal' character
In order to get your number the following regex should work fine :
Basically this says : Start at the beginning and ignore everything while you look for the first "t":, then grab everything that is a number, from the first close curly brackets go to the end and ignore everything again.
Below working sample using the text operators, but the logic goes for any replacement operator
@kayman the answer to this regular expression is ?....
I have the text chain in a field of a table, not in a document.....
@kayman thank you for your help!!!
it was the replace by parameter.....I was wrting nothing instead of $1
Now I need to convert the extracted number into a numerical type....Any idea?
Thank you very much