tr_read_text Read Text The workflow loads an unstructured list of orders, flattens field1 into 4 stream fields: - productline - customer - status - order_value Further stream fields are added based onthe capture group constructs that resolve order_status & order_date. Repeating text is removed from the order_value stream field, before the order_value is formatted: $#.00 1.0 Normal 2 / ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE 0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 2010/10/02 15:57:36.812 admin 2017/05/14 14:04:37.534 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N This guided demonstration illustrates the options available in the Text File Input step. The data in the text file is flattened, parsed to capture groups, before the price is defined with the data type: Number. 128 80 658 84 Calibri Light 11 N N 0 0 0 255 255 255 255 255 255 Y Lab 1: Text File Input 128 32 161 30 Segoe UI 11 Y N 0 0 0 255 255 255 255 255 255 Y - read a list of orders. 224 208 124 41 Segoe UI 9 N N 0 0 0 255 255 255 192 192 192 Y The RegEx expression creates 2 capture groups: order_status: (Delivered | Returned) order_date: (.+) 288 400 258 58 Segoe UI 9 N N 0 0 0 255 255 255 192 192 192 Y General Guidelines: - separator: TAB - there's a white space after Order Value: 416 208 224 58 Segoe UI 9 N N 0 0 0 255 255 255 192 192 192 Y read order list flatten rows Y discard texts change order_value metadata Y parse status discard texts Y flatten rows parse status Y change order_value metadata SelectValues Y 1 none N result status order_value order_value Number -2 -2 #.00 false false order_date order_date Date -2 -2 MMM yyyy false false

576 320 Y discard texts ReplaceString Y 1 none order_value no Order Value: $ N no no no productline no Productline: N no no no customers no Customer: N no no no

432 320 Y flatten rows Flattener Y 1 none Field1 productline customers status order_value

160 320 Y parse status RegexEval Y 1 none status result N Y N N N N N N N N order_status String -1 -1 both order_date String MMM yyyy -1 -1 both

288 320 Y read order list TextFileInput Y 1 none N N filename " N

N

1 1 N 1 N 80 0 Y N N N mixed Characters Y ${Internal.Entry.Current.Directory}\orders.txt N N CSV None Field1 String £ . , - -1 26 -1 none N 0 N N N warning error line Y en_US

160 160 Y N