Design a site like this with WordPress.com
Get started
Skip to content

Pentaho & Apache Hop Hints

Notes about using Pentaho Data Integration and Apache Hop as Non-Programmer

  • Home
  • About
  • Contact

Tag: pattern

Remove a pattern in string with RegEx

In the “Replace in string” step you can also use RegEx to remove variable content.

use Regex in Replace in String step
https://regexr.com/ can be use to try your Regex

Advertisement
Christian Gutknecht Replace in string Leave a comment June 2, 2020 1 Minute

Categories

  • Flow (2)
    • Transformation executor (2)
  • Infrastructure (1)
  • Input (6)
    • Apache Tika (1)
    • JSON Input (4)
    • Microsoft Excel Input (1)
  • Job (1)
    • Copy rows to result (1)
    • Get rows from result (1)
  • Lookup (3)
    • REST client (3)
    • Stream lookup (1)
  • Mapping (1)
    • Mapping input specification (1)
    • Mapping output specification (1)
    • Simple mapping (sub-transformation) (1)
  • Output (1)
    • insert / update (1)
  • Scripting (9)
    • Formula (1)
    • Modified JavaScript value (2)
    • Regex evaluation (3)
    • Shell (1)
    • User defined Java expression (3)
  • Statistics (1)
    • Group by (1)
  • Transform (6)
    • Calculator (2)
    • Concat fields (1)
    • Replace in string (1)
    • Row denormaliser (1)
    • Row normaliser (1)
  • Uncategorized (1)

Tags

affiliation algebra apache hop apache poi authors bash calculation carriage return Characters Command Line compare numbers comparison concat copy rows corresponding author crossref dataGrid datamining date date format Elsevier email Encoding extract format Format Conversion Formula fuzzy HTML HTML encoding java script Job json json path Mapping max maximum merge Metadata names numbers pattern pentaho persons publication_date query Regex remove replace Replace in string REST rsc ScienceDirect Scraping separator several files Shell similarity string strings subtransformation TDM Terminal text textmining Tidy transpose Unescape uri urlencode white space wildcard xlsx XML yyyy

Archives

  • May 2023
  • March 2022
  • January 2022
  • November 2021
  • July 2021
  • June 2021
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • January 2020
  • July 2019
  • May 2019
  • April 2019

Recent Posts

  • Using Cookies for REST/HTTP Calls
  • Row normaliser
  • Converting Dates – Masking
  • Extract PDF Content with Tika
  • Inititial capital of a sentence
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • Pentaho & Apache Hop Hints
    • Already have a WordPress.com account? Log in now.
    • Pentaho & Apache Hop Hints
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...