Talend - tFileInputRegex
My goal is to parse several text files using a RegEx, and based on match to copy file renaming it (including regex match string in the file name itself):
Talend project overview using tFileInputRegex:
Regex should find all rows matching "Invoice - xxxxx" or "Num.Ord - yyyyy".
So I can have files like this (Invoice - 10044165 RI):
Company XXX, LLC Page Number- 1
P.O. Box 26610 I N V O I C E Date - 02/15/05
Miami, MI 64196 Customer - 20035
Lot Potency. 50006427
Brn/Plt - 100780000
REMIT TO: Order Nbr - 242242 SO
. Invoice - 10044165 RI
Or like this (Num.Ord - 50006427):
Company XXX, LLC Page Number- 1
P.O. Box 26610 I N V O I C E Date - 02/15/05
Miami, MI 64196 Customer - 20035
Num.Ord - 50006427
Brn/Plt - 100780000
REMIT TO:
.
126 Ctest
Chicago, IL
I'm trying to figure it out how to have a working OR Regex searching for rows containing "Num.Ord" OR "Invoice". I've tested online with a regex parser and this one works:
[\n\r].*(Invoice|Num.Ord)\s*-\s*([^\n\r]*)
When I try to import in Talend component tFileInputRegex, using appropriate notation, it does not work (no match on OR "Num.Ord"):
"[\\n\\r].*(Invoice|Num.Ord)\\s*-\\s*([^\\n\\r]*)"
Finally I've sorted out by parsing again with another tFileInputRegex Talend component with files rejected by first one:
Talend job schema:
- How do I pass a variable into regex with Node js?
- How do I use regex in a SQLite query?
- Python RegEx: match words in a string only if they are not preceded by a specific character
- Regular expression that ignores HTML entities
- Allow access to page only from certain referrer
- Regex to match string containing two names in any order
- Matching boot times from log using sed -E
- Validate Bangladeshi phone number with optional +88 or 01 preceeding 11 digits
- Split address and numbers
- Using setCustomValidity stops input from validating
- Use dynamic (variable) string as regex pattern in dart
- Regular expression matching Android package name
- Replace commas not inside single quotes with an @ symbol
- Visual Studio Code Search and Replace with Regular Expressions
- Split string on commas not inside double quotes
- Replace inner letters inside words that start with and end with a specific letter with the same amount of a specific character
- regex for expression with one separator hyphen
- Extracting specific data from a string with regex and Powershell
- Parse datetime string in Ydm.His format
- Extract all words double wrapped in curly braces
- Parse dot-delimited video filename to extract show title, series number and episode number
- Split a string into words, preserving contractions but removing leading apostrophes from words
- Split string on pipes which are not between square braces
- Simple regex pattern for email
- How to extract filename without extension in Makefile
- Regex pattern containing backlashes causes failure in preg_replace()
- preg_replace() pattern starting with < and ending with > doesn't find HTML comments as intended
- Split a string on spaces and/or commas after a word which may be preceded by a small word
- How to convert split() to preg_split()?
- Parse a string without delimiters into a 2d array