# Extract Data using Column Type (String, Integer) as Pattern **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [May 16, 2023, 8:59am UTC](https://forum.knime.com/t/extract-data-using-column-type-string-integer-as-pattern/67053 "2023-05-16T08:59:40Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![SOESCHEN](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/41988e/32.png) [@SOESCHEN](https://forum.knime.com/u/SOESCHEN)\ **Post date:** [May 16, 2023, 8:59am UTC](https://forum.knime.com/t/extract-data-using-column-type-string-integer-as-pattern/67053/1 "2023-05-16T08:59:40Z")
Hello Community, after extracting my data into in single ROW in KNIME Table,my next steps is to combine/transform them into a new table. I check/try “Unpivoting, Cell Splitter, Column Filter, Rule Engine” but i can not find howto use “regex” by Type of the Column. The Pattern for each Dataset is: Integer Column - String Column [n-1] - Integer Column The “String of Columns” have no pattern neither in count nor content, i can filter. I am strugling to find a node(s) in Knime for resolvition it. Do you have an ideas how todo ? Kind regards Sven ---
**Author:** ![ArjenEX](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/a/97f17d/32.png) [@ArjenEX](https://forum.knime.com/u/ArjenEX)\ **Post date:** [May 16, 2023, 9:39am UTC](https://forum.knime.com/t/extract-data-using-column-type-string-integer-as-pattern/67053/2 "2023-05-16T09:39:21Z")
Hi @SOESCHEN Welcome to the KNIME Community! Can you supplement your question with an example of your current input (preferable in a workable format) and draft the expected output? At the moment it’s a bit hard to imagine what’you’re looking for. In general, some nodes support regex based processing whenever a valid expression is used. ![image](https://forum-cdn.knime.com/uploads/default/original/3X/7/1/71f1db1269d60affdd4328817fe672957c8de909.png) ---
**Author:** ![SOESCHEN](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/41988e/32.png) [@SOESCHEN](https://forum.knime.com/u/SOESCHEN)\ **Post date:** [May 16, 2023, 11:36am UTC](https://forum.knime.com/t/extract-data-using-column-type-string-integer-as-pattern/67053/3 "2023-05-16T11:36:57Z")
[Extract\_PDF\_Content.knwf](https://forum.knime.com/uploads/short-url/8P0GQ91ZvQTMDWojW38DIPtjUA7.knwf) (35.5 KB) [Content\_pdf\_rename\_it.txt](https://forum.knime.com/uploads/short-url/4dnh19ojlvKZbCFGW9KT55kqwHH.txt) (400.6 KB) ---
**Author:** ![SOESCHEN](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/41988e/32.png) [@SOESCHEN](https://forum.knime.com/u/SOESCHEN)\ **Post date:** [May 16, 2023, 12:04pm UTC](https://forum.knime.com/t/extract-data-using-column-type-string-integer-as-pattern/67053/4 "2023-05-16T12:04:50Z")
@ArjenEX, please find attached an example .During the pre of the workflow, i found for me too , that the structure is 100% which i described. I rebuild the workflow without the internal documents. Is that sufficient for understanding ? ---
**Author:** ![Daniel\_Weikert](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/d/e47c2d/32.png) [@Daniel\_Weikert](https://forum.knime.com/u/Daniel_Weikert)\ **Post date:** [May 16, 2023, 5:40pm UTC](https://forum.knime.com/t/extract-data-using-column-type-string-integer-as-pattern/67053/5 "2023-05-16T17:40:06Z")
Is that really a consistant pattern you get when you read the pdf? I tried tika parser with your pdf and get inconsistent results back br ---
**Author:** ![SOESCHEN](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/41988e/32.png) [@SOESCHEN](https://forum.knime.com/u/SOESCHEN)\ **Post date:** [May 17, 2023, 6:19am UTC](https://forum.knime.com/t/extract-data-using-column-type-string-integer-as-pattern/67053/6 "2023-05-17T06:19:24Z")
I re-run the workflow with this pdf serveral times. My output is everytime the same. The PDF is based on Template. Otherwise the extraction is not a consistent pattern. But back to my questions - with the regex howto use it. Is there a Examples ? Can these combine with Flow variables ? ---
**Author:** ![Daniel\_Weikert](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/d/e47c2d/32.png) [@Daniel\_Weikert](https://forum.knime.com/u/Daniel_Weikert)\ **Post date:** [May 17, 2023, 4:27pm UTC](https://forum.knime.com/t/extract-data-using-column-type-string-integer-as-pattern/67053/7 "2023-05-17T16:27:56Z")
Sorry for being inprecise. I meant are your columns following a consistent pattern like topic1, 1\_1, 1\_2,1\_3, topic2, 2\_1, 2\_2, 2\_3, … That was not the case on my end br ---
**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\ **Post date:** [August 15, 2023, 4:28pm UTC](https://forum.knime.com/t/extract-data-using-column-type-string-integer-as-pattern/67053/8 "2023-08-15T16:28:37Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.